Query get complete Sqlserver server configuration

Posted: April 8, 2009 in Sqlserver

 

Select SERVERPROPERTY(‘Collation’) as Collation,
SERVERPROPERTY(‘EDITION’)as EDITION ,
SERVERPROPERTY(‘BuildClrVersion’)as dotNetBuildClrVersion,
SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’)as ComputerNamePhysicalNetBIOS,
SERVERPROPERTY(‘EngineEdition’)as EngineEdition,
SERVERPROPERTY(‘InstanceName’)as InstanceName,
SERVERPROPERTY(‘IsClustered’)as IsClustered,
SERVERPROPERTY(‘IsFullTextInstalled’)as IsFullTextInstalled,
SERVERPROPERTY(‘IsIntegratedSecurityOnly’)as IsIntegratedSecurityOnly,
SERVERPROPERTY(‘IsSingleUser’)as IsSingleUser,
SERVERPROPERTY(‘MachineName’)as MachineName,
SERVERPROPERTY(‘LicenseType’)as LicenseType,
SERVERPROPERTY(‘ProcessID’)as ProcessID,
SERVERPROPERTY(‘ProductVersion’)as ProductVersion,
SERVERPROPERTY(‘ProductLevel’)as ProductLevel,
SERVERPROPERTY(‘ResourceLastUpdateDateTime’)as ResourceLastUpdateDateTime,
SERVERPROPERTY(‘ResourceVersion’)as SqlserverResourceVersion,
SERVERPROPERTY(‘ServerName’)as ServerName

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s