Query for SQL Server Information

Have you ever wanted to know basic information about your SQL server?  You can use the SERVERPROPERTY command to retrieve that information with a query. Note that SERVERPROPERTY(ComputerNamePhysicalNetBIOS) will return the Physical Name of the active server.  If you...