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

[Back to original message]