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')

What scripts do you run that you can share with the group?

Editor's Picks

Free Newsletters, In your Inbox