SQL Query To Return Your SQL Servers Property Information

 

This SQL Query will allow you to retrieve Property information about your SQL server.

 

SQL Query:

 

Select

ServerProperty('ServerName') 'Server Name',

ServerProperty('ComputerNamePhysicalNetBIOS') 'Physical Machine',

 

'Instance Name' = Case

When ServerProperty('InstanceName') Is NULL Then ''

Else '<Unknown>'

End,

 

ServerProperty('Edition') 'Edition',

ServerProperty('ProductLevel') 'Product Level',

ServerProperty('ProductVersion') 'Product Version',

 

'Clustered' = Case

When ServerProperty('IsClustered') = 0 Then 'No'

When ServerProperty('IsClustered') = 1 Then 'Yes'

Else '<Unknown>'

End,

 

'Integrated Security' = Case

When ServerProperty('IsIntegratedSecurityOnly') = 0 Then 'No'

When ServerProperty('IsIntegratedSecurityOnly') = 1 Then 'Yes'

Else '<Unknown>'

End,

 

'Single User Mode' = Case

When ServerProperty('IsSingleUser') = 0 Then 'No'

When ServerProperty('IsSingleUser') = 1 Then 'Yes'

Else '<Unknown>'

End,

 

'Number Of Licenses' = Case

When ServerProperty('NumLicenses') Is NULL Then ''

Else '<Unknown>'

End,

 

ServerProperty('LicenseType') 'LicenseType'

 

 

Published Sunday, November 16, 2008 7:45 PM by dhite
Filed under:

Comments

No Comments