February 25, 2004 at 9:31 am
One of our developers complains of this senario:
Two triggers (For Insert and Delete) have been working for years.
The triggers are created in database A and run on both database A and database B.
The developer deleted the the 'Insert' trigger and recreated it.
The 'Insert' trigger no longer works in database B after the re-creation but the 'Delete' trigger still works.
All the triggers have dbo ownership.
Any ideas for the solution to this problem will be appreciated.
Thanks,
Nelson.
February 25, 2004 at 1:51 pm
I'd double check that it is truly recreated correctly on the right table, same owner, etc.
February 25, 2004 at 2:37 pm
Make sure that there is no other triggers created for the table using
sp_helptrigger
Linto
March 4, 2004 at 1:07 pm
is the trigger enabled?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply