I am wondering that SQL server 2000 has any facility to disable or enable triggers.
how can we look at disabled triggers in sql server2000?
How can we find which trigger is attached to which table?
when i ran following TSQL in appropriate data base,
SELECT * FROM SYSOBJECTS WHERE TYPE='TR'
i can see the trigger that i am after,but can't see which table it's attached to.
when I right click the table/all tasks/manage triggers and then clicked drop down box to see triggers,i could able to see before,but i can't see now for some known triggers.why?
any help is much appreciated.
thanks in advance