Linked Server

i have 2 servers which are remote. i have connected them through the linked server option. since they are remote, the names were the ip address.
if i look into the tables, i can see the tables.

i am stuck with actualy referecing or querrying those tables. how do i querry a remote server which is linked using the linked server option??

thnks!i have 2 servers which are remote. i have connected them through the linked server option. since they are remote, the names were the ip address.
if i look into the tables, i can see the tables.

i am stuck with actualy referecing or querrying those tables. how do i querry a remote server which is linked using the linked server option??

thnks!
Look in SQL Books for OPENROWSET or OPENQUERY.

regards,

hmscott|||This works for me:

[ServerName].DatabaseName.Owner.TableName|||the differance between the 4 part table name and OPENQUERY is that the first processing the query from the calling server and the latter from the linked server.