CODEWITHSUNDEEP
sqlsql-server-2008triggers
Bellemorte79
Bellemorte79

Reputation: 11

Missing Trigger in SQL Server 2008

A previous colleague created a table and trigger on a database. The table was recently dropped because it was no longer needed. The users are getting an error in the code that indicates to me the trigger is still out there. Regretfully I cannot find the trigger.

The table is gone so it's not listed under there. It's not in Server Object --> Triggers. It's not in Programmability --> Triggers. I'm not sure where else it is hiding. I've rebuilt the table so the code can run without error. We have another DB that mirrors this one and the trigger there is unlocatable, as well. 

CREATE TRIGGER trig_int_user ON int_user FOR INSERT, UPDATE, DELETE

I don't think there is anything really special about this trigger and it doesn't include anything like Server ALL to indicate the entire server has it. I really just need to hunt it down so I can get rid of it.

Upvotes: 0

Views: 164

Answers (1)

Bellemorte79
Bellemorte79

Reputation: 11

I did a query and found the table it was on. I have it deleted and the table I recreated dropped.

Upvotes: 1

Related Questions