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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy