SQL Server Tacklebox- P8: This book, as with almost all books, started out as an idea. I wanted to accumulate together those scripts and tools that I have built over the years so that DBAs could sort through them and perhaps adapt them for their own circumstances. | 2 The SQL Server landscape WHEN SERVERPROPERTY EditionID 4161255391 THEN Express Edition with Advanced Services END AS ProductEdition CASE WHEN CONVERT CHAR 100 SERVERPROPERTY IsClustered 1 THEN Clustered WHEN SERVERPROPERTY IsClustered 0 THEN Not Clustered WHEN SERVERPROPERTY IsClustered NULL THEN Error END AS IsClustered CASE WHEN CONVERT CHAR 100 SERVERPROPERTY IsFullTextInstalled 1 THEN Full-text is installed WHEN SERVERPROPERTY IsFullTextInstalled 0 THEN Full-text is not installed WHEN SERVERPROPERTY IsFullTextInstalled NULL THEN Error END AS IsFullTextInstalled CONVERT CHAR 100 SERVERPROPERTY SqlCharSet AS SqlCharSet CONVERT CHAR 100 SERVERPROPERTY SqlCharSetName AS SqlCharSetName CONVERT CHAR 100 SERVERPROPERTY SqlSortOrder AS SqlSortOrderID CONVERT CHAR 100 SERVERPROPERTY SqlSortOrderName AS SqlSortOrderName ORDER BY CONVERT CHAR 100 SERVERPROPERTY Servername Listing Server information. As you can see it s a pretty simple script that makes liberal use of the SERVERPROPERTY function to return the required data. MRQueey Ml -Ur um La M J . UM Ari we. o r rK th ts nd corratud XAQuwya i - M rweerted UAKAtiywe Jl ar 7. d-nat nr j SELECT CONVERT CHAR 100 3ERVZRPROPEFTTI Servernane A3 Server CCNVERT iCHARIOO . SERVERPROPERTT I Productversion I AS Productversion CCNVERT CHAR 100 . SIRVERPROPERTT I ProductLev 1 AS ProductLovel. CCNVERT CHAR 100 3ERVEPPR0PEFTT RescurceLaatDpdatePaceTuae A3 ResourceLaatVpdateDateTMK. CCNVERT CHAR TOO . SERVERPROPEFTT I RcsouXCeVerSloa i AS ResoarceVers ion. CASE WHEN SERVERPROPERTT IsIntegratedSecur ityOnly I - 1 Tirol Integrated eecurity VKDC SERVERPROPERTTi IsIntegratedJeeur ityOnly- i 0 THEN Mol Integrated security EAT AS la EntegratedSecurityte ly. CASE VEEN 3ERVERPRCPERTTI EcgiMEdlt lot 1 thin Personal Edition HEN SERVERPROPERTYC EoglncEdltlos i 1 THEN Standard Edition UKEN 3ERVERPR0PERTY EngineEdteiori I 1 TUX Enterprise Edition WHEN SERVERPROPERTTi EngineEdlt Ion - 4 THEN Express Edition EXD as EnginsEditioa. CCNVERT
