To find out what version of SQL is running along with the service pack run the following SQL Query:

SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘journal’)

Feel free to email me clint@kbomb.com.au if you have any questions about this post.

Check it out:Clint Boessen’s Blog