Tuesday, November 17, 2015


I decided to expand upon my SERVERPROPERTY script this morning... there are a lot of other properties beyond just the name of the instance.  :-)  I put this one together quickly, should work well if you're looking at configuration or other settings, and you'd like to see all server properties at once. 

     /* Use SERVERPROPERTY to collect details regarding the server instance. */
     DECLARE @serverproperty TABLE (property sysname)
     INSERT INTO @serverproperty(property)

     -- pull them back out
            SERVERPROPERTY(Property) Value

Here's a piece of the output from one of my own instances:

Take a look at this for more SERVERPROPERTY details from MSFT:  

No comments:

Post a Comment