are those tools free?

any one you would recomend?

When dealing with linked servers is there any trouble running the trigger from sql server 2000 to put data in SQL server 2005?

I have tried it and i am having...

how would i do that?

would you point me to some examples or readings that i can go through please?

thank you for your time

sincerely

Just one extra detail:

The databases are on diferent servers. But the servers are on the same domain. My intranet.

now i just ran it again and now error was produced but no result aswell

just to do a test i tried to do the operation from the comand line and...

The error that i am getting is:

'application.exe' is not recognized as an internal or external command,

operable program or batch file.

yup i have the application that i would like to run on the same machine as the sql server.

just something really dodgy that is happeneing now is:

i modified the...

I have been trying to get the trigger to execute my external program  but it does not seem to work...I will paste my whole script here.....I cant figure out why...

Dear Terry

That was exactly what i was interested in. I will try that approach now.

Only one addition to the post:

Can the trigger receive a return value from the batch...