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

Change Password in Windows Server 2012

Using WinDBG to Debug SharePoint & Cheatsheet

Modify DataView XSLT to Add Url in Grid to Workflow Initiation Form