jrey
Posts: 1
|
| Posted: 06/15/2005, 12:55 AM |
|
Dear Support,
I am facing following issue and I really need your help :
when updating a record in a sql server table, the error messages generated by 'raiserror' are not always displayed.
The table I am trying to update has a very long trigger that does updates, checks and raises errors. If the error is raised before any update, the error message is displayed correctly, but if there is updates done before the error is raised, no error message is displayed on the web page.
I notice the following in SQL Query Analyzer : when I execute the update using the sql command, I have the following log in the server message ;
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
Server: Msg 50000, Level 16, State 1, Procedure trg_instance_update_instance, Line 115
-E- This Unix account is already used by an instance on this node.
I think the problem comes from the fact there is update message before the error message, but I see no solution 
I cannot update the trigger to do the check and raise errors before the updates unfortunately
Have you any suggestion ?
Thanks in advance !!
|
 |
 |
|
