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

[pallavikiran]

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.

[ck9663]

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