SQL Tips

How to identify your version of your Microsoft SQL Server, these handy query to do open a query in SQL Management Studio works on SQL2000 and 2005 ... to identify if your service packs are correctly applied

GO
use Master

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


More information in:
http://support.microsoft.com/kb/321185