Browse by Tags

• best practice
• collation
• edition
• engine
• license
• server property
• service pack
• sql server
• tables
• trigger
• tsql

TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?
21 December 07 02:34 AM | SQL Master | 2 Comments   

Use the following TSQL SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName') InstanceName, SERVERPROPERTY('IsClustered') IsClustered, SERVERPROPERTY('IsFullTextInstalled') Read More...

Filed under: tsql, sql server, collation, edition, version, best practice, engine, license, service pack, server property

TSQL to find all triggers in a database including their count
23 August 07 01:28 AM | SQL Master | 2 Comments   

For SQL Server 2000 version: SELECT S2.[name] TableName, S1.[name] TriggerName, CASE WHEN S2.deltrig = s1.id THEN 'Delete' WHEN S2.instrig = s1.id THEN 'Insert' WHEN S2.updtrig = s1.id THEN 'Update' END 'TriggerType' , 'S1',s1.*,'S2',s2.* FROM sysobjects Read More...

Filed under: tsql, sql server, tables, trigger, version