Linked Server

Question

Linked Server

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Bijal Parekh Mr or Mrs. 500 Points: 575 More actions · Answer 1

Not Sure what you mean..but I hope this helps

Once you have added other Servers to Server A as linked server. you can use the four part name to reference any objects on the linked server like [ServerName].[databasename].dbo.[objectname].

I hope this helps

nary SSCrazy Points: 2869 More actions · Answer 2

I guess if your SP needs to pull/push data to other databases for diffrent servers then Linked Server , Open query aresimple solutions but if you means using SP in SELECT Statement it would be better if you illiustrate with example to better answer your Question.

Thanks

Narinder

U J SSCrazy Points: 2423 More actions · Answer 3

Try this one...Hope it helps 🙂

select * from openquery(linkedservername,'sp_help')