Avoiding reboots after applying a Service Pack or a hotfix to SQL is a big concern to our customers.
In SQL 2005, we have made several enhancements to help you avoid a reboot after applying Service Packs and hotfixes.
To learn about these enhancements, read our MSDN article here.
Happy reading!
Posted By: Sanchan Saxena