April 22, 2005 at 8:40 am
I am trying to code a SQL statement in which I can access information across two different servers. I have attempted coding servername.database.owner.table a and this does not show me any table information for table a. What am I doing wrong?
April 22, 2005 at 9:16 am
Have you linked the server(s), using sp_addlinkedserver (or the Enterprise Manager UI) ?
April 22, 2005 at 9:30 am
No! I haven't. Is this something that is performed just once or does it need to be executed in the DTS package each time the SQL statement is run?
April 22, 2005 at 10:11 am
check out the BOL about using OPENROWSET.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
April 27, 2005 at 9:17 am
OK. I ran the addlinkedserver SP. But, when I try to link the two tables using Build Query inside my DTS package, I get no columns for the table inside the linked server. What did I do wrong?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply