Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Error on editing instead of update trigger

Author  Topic  Anna Starting Member 20 Posts Posted - 2001-06-15 : 04:06:36 Hi, I'm coming across an error when I try and edit an instead of update trigger I created yesterday. The trigger doesn't do anything fancy. Its created on a view of a single table. I've tried deleting the trigger and recreating it, which works fine, but when I then go to edit what the trigger does via Enterprise Manager I get the following: ERROR 5: [SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION It doesn't seem to matter what the text of the trigger is, and it syntax checks correctly. I was doing exactly the same thing yesterday with no error and I'm tearing my hair out now! Any ideas?? Anna