467,917 Members | 1,434 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,917 developers. It's quick & easy.

How can I trigger a SQL2005 Stored Procedure from SQL 2000?

I am using a trigger on a table in SQL SERVER 2000. When the trigger fires I need it to execute a Stored Procedure in SQL EXPRESS 2005. I tried to do that by creating a linked server from sql 2000 to slq express.But its not linking properly.Both SQL 2000 and SQL EXPRESS 2005 are on the same machine.Can any one please send me the solution.Thanks in advance.
Oct 14 '08 #1
  • viewed: 1355
Share:
1 Reply
ck9663
Expert 2GB
First test your distributed query outside of the trigger. If everything is well then test it inside the trigger.

Also, I would recommend this as last resort. You might also just consider a scheduled job.

Kindly post what have you done so far and we can go from there.

-- CK
Oct 14 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Jason | last post: by
9 posts views Thread by Lauren Quantrell | last post: by
7 posts views Thread by ZRexRider | last post: by
reply views Thread by JohnO | last post: by
1 post views Thread by timothy.alvis | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.