Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Corobori
Posting Yak Master
105 Posts |
 Posted - 2004-04-19 : 10:37:03
|
| I am running a script where I am dropping the the Input and Update trigger before creating a new one. It seems that on some database those items do not have the name I am expecting as I am getting this message:Impossible to delete the trigger 'tblRelations_ITrig' because it doesn't exist in the system catalog (roughly translated from French).So I would like to retrieve the update and insert and trigger name prior to delete it. Where can I find that information ?jean-lucwww.corobori.com |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-04-19 : 10:49:21
|
| This code will give you the name of all triggers on your table:SELECT name FROM sysobjects WHERE OBJECTPROPERTY(id, 'IsTrigger') = 1 AND parent_obj = OBJECT_ID('tblRelations')Raymond |
 |
|
|
Corobori
Posting Yak Master
105 Posts |
Posted - 2004-04-19 : 11:09:09
|
| It looks fine. Any way of finding out which one is the Update trigger or the Insert trigger ? I ran Select * to see the other fields but couldn't see anything I could select to find out it's the Update trigger for sure.jean-lucwww.corobori.com |
|
|
|
|
|
|
Retrieve the trigger name