https://www.insidesql.org/blogs/tosc/?disp=comments en-EU http://backend.userland.com/rss 60 Thu, 21 Mar 2013 10:21:46 +0000 tosc c2208@https://www.insidesql.org/blogs/ Hello Henrik, nice merging! THX! If it is for you okay, I'd like to customize the script? cu tosc https://www.insidesql.org/blogs/tosc/2013/02/20/sql-server-information#c2208 Thu, 21 Mar 2013 09:58:03 +0000 Henrik c2207@https://www.insidesql.org/blogs/ Hello Thorsten, great script and nice idea to use Serverproperty instead @@version. I merge my script and yours to a more completer one: --> SQL Server Information &lt;-- SET nocount ON; go USE [master]; go SELECT CONVERT(CHAR(100), Serverproperty('MachineName')) AS 'MACHINE NAME', CONVERT(CHAR(50), Serverproperty('ServerName')) AS 'SQL SERVER NAME', (CASE WHEN CONVERT(CHAR(50), Serverproperty('InstanceName')) IS NULL THEN 'Default Instance' ELSE CONVERT(CHAR(50), Serverproperty('InstanceName')) END) AS 'INSTANCE NAME', @@LANGUAGE as [Language], <em>right(substring(@@version,charindex(' - ',@@version)+17,PATINDEX('%Copyright%',@@version)-27-(charindex(' - ',@@version)+17)),3) as [32,64],</em> CONVERT(CHAR(30), Serverproperty('EDITION')) AS EDITION, substring(@@version,22,(charindex(' - ',@@version)-22)) as [Version], CONVERT(CHAR(30), Serverproperty('ProductVersion')) AS 'BUILD', CONVERT(CHAR(30), Serverproperty('ProductLevel')) AS 'PRODUCT LEVEL', (CASE WHEN CONVERT(CHAR(30), Serverproperty('ISClustered')) = 1 THEN 'Clustered' WHEN CONVERT(CHAR(30), Serverproperty('ISClustered')) = 0 THEN 'NOT Clustered' ELSE 'INVALID INPUT/ERROR' END) AS 'FAILOVER CLUSTERED', (CASE WHEN CONVERT(CHAR(30), Serverproperty('ISIntegratedSecurityOnly')) = 1 THEN 'Integrated Security ' WHEN CONVERT(CHAR(30), Serverproperty('ISIntegratedSecurityOnly')) = 0 THEN 'SQL Server Security ' ELSE 'INVALID INPUT/ERROR' END) AS 'SECURITY', (CASE WHEN CONVERT(CHAR(30), Serverproperty('ISSingleUser')) = 1 THEN 'Single User' WHEN CONVERT(CHAR(30), Serverproperty('ISSingleUser')) = 0 THEN 'Multi User' ELSE 'INVALID INPUT/ERROR' END) AS 'USER MODE', CONVERT(CHAR(30), Serverproperty('COLLATION')) AS COLLATION, Getdate() AS RunTime, <em>substring(@@version,charindex (' ON ', @@VERSION)+4,(charindex (' (Build', @@VERSION))- (charindex (' ON ', @@VERSION)-1)-5) as [OS Version], substring(@@version,charindex ('Build ', @@VERSION) + 6,4) as [OS Build], case when charindex ('Service Pack', @@VERSION) = 0 then '' else substring(@@version,charindex ('Service Pack', @@VERSION) +13,1 ) end as [OS Service Pack], </em> @@SPID AS 'ID', SYSTEM_USER AS 'Login Name?', USER AS 'User Name'; go -- END SQL Server Information -- SQL Server Information <-- SET nocount ON; go USE [master]; go SELECT CONVERT(CHAR(100), Serverproperty('MachineName')) AS 'MACHINE NAME', CONVERT(CHAR(50), Serverproperty('ServerName')) AS 'SQL SERVER NAME', (CASE WHEN CONVERT(CHAR(50), Serverproperty('InstanceName')) IS NULL THEN 'Default Instance' ELSE CONVERT(CHAR(50), Serverproperty('InstanceName')) END) AS 'INSTANCE NAME', @@LANGUAGE as [Language], right(substring(@@version,charindex(' - ',@@version)+17,PATINDEX('%Copyright%',@@version)-27-(charindex(' - ',@@version)+17)),3) as [32,64], CONVERT(CHAR(30), Serverproperty('EDITION')) AS EDITION, substring(@@version,22,(charindex(' - ',@@version)-22)) as [Version], CONVERT(CHAR(30), Serverproperty('ProductVersion')) AS 'BUILD', CONVERT(CHAR(30), Serverproperty('ProductLevel')) AS 'PRODUCT LEVEL', (CASE WHEN CONVERT(CHAR(30), Serverproperty('ISClustered')) = 1 THEN 'Clustered' WHEN CONVERT(CHAR(30), Serverproperty('ISClustered')) = 0 THEN 'NOT Clustered' ELSE 'INVALID INPUT/ERROR' END) AS 'FAILOVER CLUSTERED', (CASE WHEN CONVERT(CHAR(30), Serverproperty('ISIntegratedSecurityOnly')) = 1 THEN 'Integrated Security ' WHEN CONVERT(CHAR(30), Serverproperty('ISIntegratedSecurityOnly')) = 0 THEN 'SQL Server Security ' ELSE 'INVALID INPUT/ERROR' END) AS 'SECURITY', (CASE WHEN CONVERT(CHAR(30), Serverproperty('ISSingleUser')) = 1 THEN 'Single User' WHEN CONVERT(CHAR(30), Serverproperty('ISSingleUser')) = 0 THEN 'Multi User' ELSE 'INVALID INPUT/ERROR' END) AS 'USER MODE', CONVERT(CHAR(30), Serverproperty('COLLATION')) AS COLLATION, Getdate() AS RunTime, substring(@@version,charindex (' ON ', @@VERSION)+4,(charindex (' (Build', @@VERSION))- (charindex (' ON ', @@VERSION)-1)-5) as [OS Version], substring(@@version,charindex ('Build ', @@VERSION) + 6,4) as [OS Build], case when charindex ('Service Pack', @@VERSION) = 0 then '' else substring(@@version,charindex ('Service Pack', @@VERSION) +13,1 ) end as [OS Service Pack], @@SPID AS 'ID', SYSTEM_USER AS 'Login Name?', USER AS 'User Name'; go -- END SQL Server Information --]]> https://www.insidesql.org/blogs/tosc/2013/02/20/sql-server-information#c2207 Wed, 20 Feb 2013 15:52:29 +0000 tosc c2197@https://www.insidesql.org/blogs/ ups, my fault ... it's done! THX Frank, wish you a nice day! https://www.insidesql.org/blogs/tosc/2013/02/20/sql-server-information#c2197 Wed, 20 Feb 2013 15:44:30 +0000 admin c2196@https://www.insidesql.org/blogs/ I would consider making it available as a file to download. :-) https://www.insidesql.org/blogs/tosc/2013/02/20/sql-server-information#c2196