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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-21 : 10:58:01
|
Sher writes "Hi,
I have an update trigger on my table.I developed the trigger using the SQL server 7.0. When i open this table in Enterprise Manager (when the trigger is still defined on it)and try to update some value directly, everything is fine in SQL Server 7.0
but when i try to do the same thing in SQL Server 2000 I get an error :
[Microsoft][ODBC SQL Server Driver][SQL Server] SqlDumpExceptionHandler:Process 52 Generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
when i delete the trigger and try to update, everything is fine. This makes me think that the problem is with my trigger. But then, when i do the same updating action through my web application, everything is fine. For my application, i require that i am able to update even from the enterprise manager.
Please let me know what i can do. I need the trigger to be on that table. and still be able to manage the data through the enterprise manager.
Thanks in Advance.
Sher" |
|
|
|
|
|
Trigger works in SQL 7 and Not in SQL 2000