« November 2007 | Main | February 2008 »
January 8, 2008
Determining the Order of Triggers on a Table
Here is a code block that will help determine what triggers will be fired in what order for a given table:(just fill in the proper table name you need)
declare @tablename sysname
SET @TableName = 'dbo.dttable'
select name,
ObjectProperty(object_id, 'ExecIsFirstInsertTrigger') AS FirstInsert,
ObjectProperty(object_id, 'ExecIsFirstUpdateTrigger') AS FirstUpdate,
ObjectProperty(object_id, 'ExecIsFirstDeleteTrigger') AS FirstDelete,
ObjectProperty(object_id, 'ExecIsLastInsertTrigger') AS LastInsert,
ObjectProperty(object_id, 'ExecIsLastUpdateTrigger') AS LastUpdate,
ObjectProperty(object_id, 'ExecIsLastDeleteTrigger') AS LastDelete
from sys.objects
where parent_object_id = object_id(@tablename)
and (type='TR' or type='TA')
Share:
Posted by Steve Mann at 3:43 PM | Comments (0)
SQL Server 2008 Site
There is a new SQL Server 2008 site with links to webcasts, virtual labs, and podcasts:http://www.microsoft.com/events/series/technetsqlserver2008.aspx?tab=overview
Share:
Posted by Steve Mann at 3:41 PM | Comments (0)
