using a view on a different server

[SS14]

I created a view on ServerA but I would like to use it on ServerB how can I do this. Do I need to link servers?

thanks
ss14

 

[tlbroadbent]

You can access the view on a linked server. In SQL 2000, you can also use OpenRowSet to select from a view on another server even if not linked. Check for details in SQL BOL or at MSDN.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_oa-oz_78z8.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[lardmonster]

OpenRowSet also works with SQL Server 7.0, as far as I remember --
lardmonster - an occasional visitor
mkflint@hotmail.com