Created
May 12, 2016 18:33
-
-
Save NoahDragon/cbf235f4cc410a70d01a1a857b4138d3 to your computer and use it in GitHub Desktop.
Check server name, host name, instance name, and etc. on SQL server .
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT HOST_NAME() AS 'host_name()', | |
| @@servername AS 'ServerName\InstanceName', | |
| SERVERPROPERTY('servername') AS 'ServerName', | |
| SERVERPROPERTY('machinename') AS 'Windows_Name', | |
| SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS 'NetBIOS_Name', | |
| SERVERPROPERTY('instanceName') AS 'InstanceName', | |
| SERVERPROPERTY('IsClustered') AS 'IsClustered' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment