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 SP2You can download it by visiting the Microsoft website here. Enhancements in SQL 2005 SP2SP2 provides several new features and improvements. You can learn about them here. Download SQL 2005…


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, read our MSDN article here.   Happy reading!  …


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 reporting extensive blocking on your server.   However, there is more to it…


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 you would on 32 bit versions of SQL. However,…


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 files from subfolders. As per BOL: In contrast to earlier versions of…


Update on SQL 2000 Service Pack 4

If you are running SQL Server 2000 SP4 (build 8.00.2039), you might be interested in this blog.   Since the launch of SP4 (build 8.00.2039), several hotfixes have been released publicly. At the time of writing this blog, the latest hotfix build available for public download was 8.00.2187.    Please refer to KB 894905 for…


Update on SQL 2000 Service Pack 3 and 3a

If your SQL Server 2000 is running on Service Pack 3 (build 8.00.760) or Service Pack 3a, you might be interested in this blog entry.   Since the launch of SQL 2000 SP3 and SP3a, Microsoft has released a number of hotfixes with resolutions to several known issues.   We strongly encourage you to be…


SQL 2005 Released Service Packs

Since the launch of SQL Server 2005 in November of 2005, Microsoft has publicly released the following service packs and hotfixes:   SQL Server 2005 Service Pack 1 On 18th March 2006, Microsoft released the first service pack for SQL 2005.   For a list of new features included in SP1, refer to the KB article…