Microsoft SQL Server Support Blog

SQL Server information from the folks at Microsoft Support

Browse by Tags

Tagged Content List
  • Blog Post: 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 2005 SP2 SP2 provides several new...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 18 th March 2006, Microsoft released the first service pack for SQL 2005. For a list of new features included in SP1, refer...
Page 1 of 1 (8 items)