Post reply

SQL - Use SERVERPROPERTY to get SQL Instance Information

  • December 16, 2016 at 2:10 am

    #338287

    Comments posted to this topic are about the item SQL - Use SERVERPROPERTY to get SQL Instance Information

  • December 29, 2016 at 7:06 am

    #1919988

    This is really cool, thanks.

  • December 29, 2016 at 8:37 am

    #1920013

    I'm sure this will sound like a really simple request by many, but is there an easy T-SQL method to pivot the results into two columns?

    Chris

  • December 29, 2016 at 9:14 am

    #1920020

    You can use something like this.....

    SELECT 'BuildClrVersion' ColumnName, SERVERPROPERTY('BuildClrVersion') ColumnValue

    UNION ALL

    SELECT 'Collation', SERVERPROPERTY('Collation')

    UNION ALL

    SELECT 'CollationID', SERVERPROPERTY('CollationID')

    UNION ALL

    SELECT 'ComparisonStyle', SERVERPROPERTY('ComparisonStyle')

    UNION ALL

    SELECT 'ComputerNamePhysicalNetBIOS', SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

    UNION ALL

    SELECT 'Edition', SERVERPROPERTY('Edition')

    UNION ALL

    SELECT 'EditionID', SERVERPROPERTY('EditionID')

    .

    .

    .

    .

    .

    .

    .

  • December 29, 2016 at 3:52 pm

    #1920049

    Thanks!

    Chris

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply