January 4, 2003 at 12:48 pm
Is it possible to create a view on the basis of a table of a different database from a different sql-server ? I know it sounds strange but there is a temporary requirement for it. Any suggestions or alternatives ? Thanks.
January 4, 2003 at 2:56 pm
Sure. Set up a linked server first, then just write the view using fully qualified four part syntax. If your table is Test on Server A (and you create a linked server called ServerA), it might look like this:
create view vTest as
select col1, col2 from ServerA.somedbname.dbo.test.
Andy
January 6, 2003 at 1:33 pm
Thanks for the info. How do you create linked server in the first place ?
January 6, 2003 at 2:21 pm
Books Online shows you how. Look in EM under security, has a nice GUI for doing it.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply