data from one database to another

[baran121]

hi ,
i have two database on the same server (on sql server 200).
i have a table using triggers.when the triggers occur i run stored prosecure that created on the other database.

exec argeee.dbo.GLD_ab_argee_ms @sdate,@sdate_old,@cus_code,@sku,@qty,@fl,@gd output

sometimes it works, but sometimes i get error below.

"could not find server in sysservers. Execute sp_addlinkedserver to add the server to sysservers. The statement has been terminated."

could anyone please help me in this.

 

[simian336]

exec argeee.dbo.GLD_ab_argee_ms means to run the stored procedure argeee.dbo.GLD_ab_argee_ms. You should find it in the Programmability> Syste Stored procedure section.

Once you edit it. Hopefully you can determine what it references and possibly the problem.

Simi