Tο find out whаt version οf SQL іѕ running along wіth thе service pack rυn thе following SQL Query:

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

Check іt out:Clint Boessen’s Blog