Now that you've deployed the service packs, you need to download the latest hotfix for your SQL Server products....
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
Refer to the database of SQL Server versions Web site to see the latest hotfix that is available for your supported SQL Server product. (Some of the fixes will be marked as PSS-only, which means they are only available to those who have paid for Product Support Services.)
You can also search for hotfixes by visiting the Microsoft Download Center, searching for "hotfix" and selecting "SQL Server" as the product. Once the results are returned, change the sort order to "Date" to see the latest recommended, publicly available hotfix at the top of the list.
(Note: If you have a clustered SQL Server instance or want more information on the SQL Server hotfix process, refer to the information in Knowledge Base article KB330391.)
HOW TO PATCH SQL SERVER, PART 2
Step 1: Segregate your scan results
Step 2: Obtain service packs and prepare for deployment
Step 3: Deploy service packs
Step 4: Obtain hotfixes and prepare for deployment
Step 5: Deploy hotfixes
Step 6: Re-assess network
Step 7: Plan next assessment
Back: How to patch SQL Server, part 1
ABOUT THE AUTHOR:
Chip Andrews is the director of research and development for Special Ops Security Inc. and the founder of the SQLSecurity.com Web site, which focuses on Microsoft SQL Server security topics and issues. He is also the author of SQL Server Security.