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…

clip_image002

You can run the following SQL script:

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

clip_image004

and check the version number via this link:

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx