Posted by Erland Sommarskog on 04/24/07 22:30

(pascal.baetscher@gmail.com) writes:
> 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.

So there is a an error message? What about posting it?

Overall, if it's possible, I would appreciate if you could post the
code of the stored procedure and the trigger, because I have some
problems following your narrative what is happening.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K
• Prev in forum: Re: Different UPDATE behaviors across servers
• Thread view: Re: Trigger: To fill another Database with using Stored Procedures of the other Database

[Reply to this message]