LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » Transact-SQL Programming » Stored Procedures, Triggers, & Functions » View from another instance:

View from another instance:

Options

Previous Topic · Next Topic

faifuhi

Posted: Tuesday, May 26, 2009 12:14:50 AM

Rank: Newbie

Joined: 5/26/2009
Posts: 1
Points: 3
Where do you live?: Maldives

Hi, I have been using SQL server for quite sometime now. Currently I 'm using SQL server 2005.

my question goes like this:

Is it possible to create a view inside a sql instance (on one physical server) by getting data from another instance (another physically seperated server)?

regards,

PS: i'm just curious. Just checking if it's possible, did some googling, but cudnt get anything concrete.

thanks

wdismukes

Posted: Tuesday, May 26, 2009 8:03:29 AM

Rank: PFY

Joined: 5/3/2007
Posts: 24
Points: -22
Where do you live?: Houston, Texas

I link to a production SQL 2005 hosted database from a test SQL 2008 box. The following worked for me:

CREATE VIEW LinkedServerView AS
SELECT [column list] FROM
LinkedServerName.databasename.schema.tablename;

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.