BRONZE PARTNER:
BRONZE PARTNER:
Industry News:
| |
| |
|
|
|
|
|
| SQL Query To Return Your SQL Servers Property Information |
|
|
|
By: Don Hite
Posted On: 11/18/2008
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'
|
|
|
|
|
|
