SQL 2005 – What version are you running?

I had to work on deploying SQL 2005 service pack 2.  I tend to look at the version numbers so I can make sure the upgrade is consistent.  Well, SQL 2005 was a bit interesting. 

http://support.microsoft.com/kb/936305/en-us

http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx

If you have to deploy SQL 2005, you might want to read up on the posting from the PSS team.