Dec 04 '11 at 06:23 AM
Dec 04 '11 at 11:53 AM
Dec 04 '11 at 10:40 AM
Dec 04 '11 at 10:41 AM
You'll need to look in either sys.objects where type = 'TR' and get the parent_object_id
where type = 'TR'
or [sys.triggers] and get the parent_id
Dec 04 '11 at 10:39 AM
Kev Riley ♦♦
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Dec 04 '11 at 06:23 AM
Seen: 717 times
Last Updated: Dec 04 '11 at 11:53 AM
How to move the indexes to new file group?
sql trigger to email when data input
Regarding Table sizes in Database?
How to get the SQL code of the DML that fires a trigger?
rebuild index maintainance plane?
Differences between SQL Server 2005 and 2008 when updating values
Regarding rebuild index maintainance plane job failed?
Shut down trigger in sql server 2005