Linked server

Question

Post reply

Linked server

Krasavita

SSC-Insane

Points: 23138
More actions
March 14, 2012 at 10:44 am

#265773

Hello,
Is there way not to use link server in sql server 2008? I need to select data in the view.
Thank you

Viewing 10 posts - 1 through 9 (of 9 total)

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

spaghettidba

SSC Guru

Points: 105732

March 14, 2012 at 12:14 pm

#1459429

????

-- Gianluca Sartori

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Yes, you can use a linked server in 2008. You can also use a view in 2008.

Can you detail your question a bit more?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

Agreed.. WHAT?

You need to give us a LOT more information. I would equate this to "its broke, how do I fix it?"

CEWII

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

I'm going to frame this one.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Jared SSC Guru Points: 61793 More actions · Answer 5

Taking a stab... I think the OP is asking if there is a way NOT to use a linked server to gather data from another server for the view. I say use OPENROWSET, which is not new in 2008. It was in 2005 as well.

Jared
CE - Microsoft

Lowell SSC Guru Points: 323518 More actions · Answer 6

SQLKnowItAll (3/14/2012)
Taking a stab... I think the OP is asking if there is a way NOT to use a linked server to gather data from another server for the view. I say use OPENROWSET, which is not new in 2008. It was in 2005 as well.

I was thinking the same thoughts as well;

it also depends on how 'fresh" the data needs to be and how much the source table changes;

the table could be replicated, or an SSIS job might copy it at intervals, or some process might just do a TSQL MERGE once in a while.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 7

If the OP would ever come back and explian what he was really looking for it might help..

CEWII

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Elliott Whitlow (3/16/2012)
If the OP would ever come back and explian what he was really looking for it might help..
CEWII

Couldn't agree more.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Gazareth One Orange Chip Points: 27737 More actions · Answer 9

Koen Verbeeck (3/14/2012)
I'm going to frame this one.

I think you should! 😀