disabling a trigger from a stored procedure in another database

[lisa clague]

I want to disable a trigger on a table in a database from inside a stored procedure in another database.
Can I disable then enable? Do I have to drop then recreate the trigger?
How do I code it? I've tried several ways but I can't get it right...

[Karl]

Lisa,

try the following:

ALTER TABLE databasename.ownername.tablename DISABLE TRIGGER triggername.

Hope this helps,

Karl




------------
lisa clague at 11/17/00 12:50:36 AM

I want to disable a trigger on a table in a database from inside a stored procedure in another database.
Can I disable then enable? Do I have to drop then recreate the trigger?
How do I code it? I've tried several ways but I can't get it right...