July 6, 2004 at 8:30 am
Hi, I'm using SQL Server 7. I created an insert trigger on a table, and it is working correctly. But how do I now edit it in enterprise manager?
If I right-click on the table, all tasks, manage triggers, all I get is
Also, I have just noticed that if I click on all tasks, display dependancies, this error comes up:
Error 21776: [SQL-DMO]The name 'trigger_SetImagePath' was not found in the Triggers collection. If the name is a qualified name, use [] to separate the various parts of the name, and try again.
(after clicking ok to the error, my trigger IS listed correctly in the dependancies!!!)
I must be doing something stupid... I'd appreciate it if someone pointed it out because I don't get it!
July 6, 2004 at 11:22 am
Many times EM functionality doesn't work properly until the item affected is refreshed. I would first try refreshing the table in question (right click and select refresh), then the database if the table doesn't work. Last resort, restart Enterprise Manager. I don't know if this is the problem you are experiencing, but it sounds like it.
Steve
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply