SQL 2005/2008 Query Current Version and Configuration Settings

This T-SQL query will list the current SQL version and configuration settings for the current instance for SQL Server:  
 
sp_configure 'show advanced options', 1
reconfigure
GO
sp_configure
GO
SELECT SERVERPROPERTY('productversion') as ProductVersion
SELECT SERVERPROPERTY ('productlevel') as Level
SELECT SERVERPROPERTY('edition') as EDITION
SELECT @@VERSION as VERSION

Comments

Popular posts from this blog

WinDBG on 32Bit Applications

EXCEL Macro - Compare Column A to Column B

Powershell Script to Automatically Deploy Sharepoint WSP Packages