By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,574 Members | 1,968 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,574 IT Pros & Developers. It's quick & easy.

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

P: 1
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
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
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.