|
|
Posted by pascal.baetscher on 04/24/07 14:15
Hello everyone,
I face currently a problem where I could need some input for searching
the source of the Problem
System: SQL Server 9.0
I fill from Database A with triggers Database B, everything works
fine.
On Database B there is a Stored Procedures that checks the records and
add additional information accordingly, this Stored Procedures is
normally called by the application on "update and insert" in the
according table.
When I try to call this Stored Procedures from the Database A, the
trigger does not work anymore, even if I do a try catch over the whole
trigger, he never reach the Catch and the insert I try to do there to
get the error message.
On both Databases the user, that is taken to execute the trigger is
existent and DB-Owner of both Databases.
If I go and execute the Stored Procedures manually after an insert or
update to Database B everything works fine.
I also already tried to check on Database B if there is an insert or
update from Database A and if, to execute the Stored Procedures, with
the same result, nothing and all happens anymore, neither update on
Database A and also not on Database B.
And also I cant catch the error as the Try/Catch is not working.
Hope I could explain it understandable and maybe someone remembers
already having the same problem.
Thanks & Best regards
Pascal
Navigation:
[Reply to this message]
|