September 1, 2009 at 12:40 am
How do I delete this post? I posted in SQL2008 board?
Hi,
I have two databases on seperate servers
1) Primary (SQL2000)
2) Secondary (SQL2005)
I want to run the following query twice everyday (automatically) in the Primary..
select field1,field2
from table_name
where condition
The output should be stored to a table in the secondary server.
How do I go about it? I am new to SQL. Can someone help me out over here?
Thanx in advance
September 1, 2009 at 8:58 am
You need to use linked servers. Add the secondary server as linked server in the primary one. Read a little about linked server you will get an idea.
Your query will be like this when fired from primary
select field1,field2
from seconadaryserver.databasename.schemaname.table_name
where condition
I assume that the table_name is on the secondary server. In case you wan to automate it then you can use sql agent jobs to do it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply