I don't understand why a trigger works fine when fired from a statement in the Query Analyzer, but when fired by making a change to the table directly in the EM I get ODBC errors, first 'SqlDumpExceptionHandler: Process x generated fatal exception'. Then 'Communication Link Failure'. Since the...
When adding records to a table in the Enterprise Manager, I normally get the error messages from the Raiserror command in the trigger. When the Raiserror follows an "IF @@ROWCOUNT = 0" the message is "Data has changed since the Results pane was last updtated..." When...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.