Check SQL Version
Guys,
If you need to check the version number (eg. 9.0.3042) so you can verify what SQL service pack is installed…
You can run the following SQL script:
SELECTÂ SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
and check the version number via this link:
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx