May 29, 2007 at 1:21 am
Dear all
I have the following problem.
I have a sql server 2000 database that is my production database. In there there is a table for employees. When an employee gets added in this database i would like to send those details to another database .The second database is SQL SERVER 2005 database.
Has anyone ever had any experience with this?
Any help is apreciated.
Sincerely
Dan
May 29, 2007 at 1:39 am
Just one extra detail:
The databases are on diferent servers. But the servers are on the same domain. My intranet.
May 29, 2007 at 4:39 am
A trigger, linked servers should be fine for your effort did you try that.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
May 29, 2007 at 6:56 am
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
May 31, 2007 at 5:49 pm
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 some problems to get data from 2000 in 2005. I get a General Networking error and it says to check the documentation but there is nothing i could find online in regards to this.
But when i run the trigger on the 2005 side i dont have any troubles.
Is this a known issue or am i doing something wrong.
I tested the connections by pinging and everything else and that is all good. There are no proxies and firewals.
Cheers
Dan
June 4, 2007 at 5:54 am
Hi Dan,
Firstly, check if your linked server is functional. You should check your dcom rights because your sql server instances are on different stations. If you logon on stations with users of users group you should give access rights to anonymous logon on dcom rights. If you logon on stations with administrator user you should give access rights to Everyone logon on dcom rights.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply