Data Management

What version of SQL Server are you running?


I have run into the situation several times where I had to determine which version of SQL Server 2005 is running (including service pack). To accomplish this task, connect to the SQL Server Management Studio and run the following TSQL statement:

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

0 comments

Editor's Picks