Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Service Pac... » SQL Tips and Tricks   (RSS)
Monday, February 19, 2007 1:14 PM

SQL 2005 SP2 is available now!

Finally, after rounds of CTPs (Community Technology Previews) and great feedback from customers, we have officially released Service Pack 2 (SP2) for SQL 2005. Download SP2 You can download it by visiting the Microsoft website here . Enhancements in SQL
Posted by sqlblog | 1 Comments
Wednesday, December 06, 2006 3:16 PM

How can I limit the number of reboots when applying hotfixes and the like to SQL Server and OS?

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,
Posted by sqlblog | 1 Comments
Thursday, September 21, 2006 10:42 PM

Why is a SPID blocking itself in sysprocesses? How is it possible?

After you apply SQL 2000 Service Pack 4, you might observe that a SPID is blocking itself, as reported in the output of sysprocesses. If your custom scripts/applications monitor blocking by relying on the output of sysprocesses column, they will start
Posted by sqlblog | 1 Comments
Sunday, September 17, 2006 4:11 PM

ENHANCEMENT - Database Mail in SQL 2005 64 bit and SP1

Database Mail is a new feature in SQL 2005 that provides enterprise class mailing functionality in SQL 2005 32 bit and 64 bit versions. SQL Server 2005 RTM x64/IA64 In SQL 2005 RTM x64 and IA64 bit versions, you can use Database Mail features just as
Posted by sqlblog | 1 Comments
Sunday, September 17, 2006 4:05 PM

ENHANCEMENT - Maintenance Cleanup Task and SP1

Maintenance Cleanup Task can be used to remove files related to Maintenance Plans. You can learn more about it in BOL here . SQL 2005 RTM (32bit and 64bit) In SQL Server 2005 RTM, the Maintenance Cleanup Task doesn't allow you to delete maintenance plan
Posted by sqlblog | 2 Comments
 
Page view tracker