Torsten Schuessler - Latest Comments

Torsten Schuessler [Member] in response to: SQL Server Information

Torsten Schuessler [Member] — Thu, 21 Mar 2013 10:21:46 +0000

Hello Henrik,

nice merging! THX!
If it is for you okay, I'd like to customize the script?

cu
tosc

Henrik [Visitor] in response to: SQL Server Information

Henrik [Visitor] — Thu, 21 Mar 2013 09:58:03 +0000

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

Torsten Schuessler [Member] in response to: SQL Server Information

Torsten Schuessler [Member] — Wed, 20 Feb 2013 15:52:29 +0000

ups, my fault
...
it's done!
THX Frank, wish you a nice day!

Frank Kalis [Member] in response to: SQL Server Information

Frank Kalis [Member] — Wed, 20 Feb 2013 15:44:30 +0000

I would consider making it available as a file to download. :-)

Torsten Schuessler [Member] in response to: Kostenloser PASS-Vortrag "Performance & Manageability der tempdb“ - 19.02.2013 - Nürnberg‏

Torsten Schuessler [Member] — Wed, 20 Feb 2013 15:30:25 +0000

Danke, hat mir sehr viel Spaß gemacht.
Die Präsentation findet Ihr unter: Repository - Franken |Regionalgruppentreffen 2013

cu
tosc

Robert Glöckner [Visitor] in response to: Kostenloser PASS-Vortrag "Performance & Manageability der tempdb“ - 19.02.2013 - Nürnberg‏

Robert Glöckner [Visitor] — Wed, 20 Feb 2013 14:49:44 +0000

Toller Vortrag gestern, danke sehr!
Gruß aus Nürnberg
Robert Glöckner

Sa [Visitor] in response to: SQL Server 2005/2008 Express free Profiler Tool

Sa [Visitor] — Wed, 10 Oct 2012 09:42:56 +0000

Good

Torsten Schuessler [Member] in response to: Antivirus Software on SQL Server

Torsten Schuessler [Member] — Fri, 21 Sep 2012 05:33:14 +0000

It may be a hard discussion, but - "It depends on ...