List of versions and bugs fixed on SQL Server 2008 Service Pack 2 (CTP)

I had to answer bunch of questions around version number and fixes that are released for SQL Server 2005 &amp; 2008, during a SQL Server platform health check for a client yesterday.. First one was, what is easy way to determine which version (service pack release) of SQL Server is running :As 2000 version is still operational (most of the places) I would say run the following TSQL against the registered SQL instances on your network: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),...(<a href="http://sqlserver-qa.net/blogs/sql2008/archive/2010/07/21/9351.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9351" width="1" height="1">