Thursday, October 18, 2012

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

No comments:

Post a Comment