Service pack 2 for SQL Server 2005 is ready!

For the users of Visual Studio Team Edition for Database Professional there are some important fixes in this service pack. The good news is that all fixes are related to the BatchParser which is a shared component that we from SQL Server which is part of SQL Server SMO. This means if you just want to install these fixes you can simply install the XMO redist MSI to update SMO and the BatchParser. 

The XMO redist is part of the SQL Server Feature Pack

x86: http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/SQLServer2005_XMO.msi

x64: http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/SQLServer2005_XMO_x64.msi

If you are running Vista, you should install the full SQL Server 2005 SP2 service pack or if you are using SQL Express 2005 you should be up installing the SQL Server 2005 SP2 Express version

More information on SQL Server 2005 SP2 can be found on http://www.microsoft.com/sql/sp2.mspx

-GertD