SQL - Use SERVERPROPERTY to get SQL Instance Information

Question

Viewing 0 posts

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

akljfhnlaflkj Newbie Points: 0 More actions · Answer 1

Newbie

Points: 0

December 29, 2016 at 7:06 am

This is really cool, thanks.

Chris93147 Newbie Points: 0 More actions · Answer 2

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

Sreekanth B Newbie Points: 0 More actions · Answer 3

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')

.

Chris93147 Newbie Points: 0 More actions · Answer 4

Newbie

Points: 0

December 29, 2016 at 3:52 pm

Thanks!

Chris

Cookies on SQLServerCentral