Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

An Introduction To Linked Servers Expand / Collapse
Author
Message
Posted Thursday, May 27, 2004 7:03 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:51 AM
Points: 269, Visits: 132
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kso


Post #118120
Posted Tuesday, August 10, 2004 8:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 10, 2004 7:51 PM
Points: 1, Visits: 1
It's very interesting.
Post #131087
Posted Thursday, June 2, 2005 8:58 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 13, 2009 6:06 AM
Points: 139, Visits: 2

Can you link to more than one (eg. sybase) server?

 

 

 

Post #187289
Posted Friday, March 24, 2006 4:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 2, 2007 11:58 PM
Points: 1, Visits: 1
wow, it is very useful to me.. thank you buddys.... .
Post #268166
Posted Friday, June 8, 2007 2:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 8, 2013 5:48 AM
Points: 4, Visits: 40

A great article, but something worth noting is that when a query is executed against a linked server using "select stuff from linkedServer.dbName.owner.objectName" SQL Server actually returns all the rows from the table(s) in the linked server and the executes the query locally (using T-SQL syntax), whereas when you use the OpenQuery() syntax the query is passed down to the linked server and only the result set is returned, this means that OpenQuery() needs to use the native syntax of the linked server rather than t-sql (assuming it's not a SQL Server!).  This was my experience at least and if I'm slightly off the mark then I'd welcome further comment.

Thanks for an interesting article




Post #372259
Posted Friday, June 8, 2007 6:01 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 22, 2012 8:41 AM
Points: 26, Visits: 75
Very good article.

Okay, so when using OPENROWSET, it is using OLE DB. How about using LINKEDSERVER itself? Is it still OLEDB based connection? or ODBC ?
Post #372296
Posted Friday, June 8, 2007 7:19 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 23, 2013 9:22 AM
Points: 1,062, Visits: 355

one more note: Link server does not support access on SQL Server 2005 64 bit

 

mom




Post #372328
Posted Friday, June 8, 2007 7:32 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 5, 2013 12:19 PM
Points: 371, Visits: 797

Very basic article. Even so it is explained in the article header, I would like to add that linked servers were available from SQL 7(or 6.5?) and did not change on introductory level since.

I would also assume that in SQL 7 processinf heterogenous queries had more flexibility than in SQL 2005. I would expect from SQLservercentral publications more indpeth, detailed coverage.

Post #372344
Posted Friday, June 8, 2007 8:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 18, 2013 1:23 PM
Points: 36, Visits: 113

Very good article.

 

Post #372386
Posted Friday, June 8, 2007 9:08 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 4:29 PM
Points: 820, Visits: 2,026

Good introduction.  I expect more in-depth articles on this subject to follow.

I have used this to attach, remote SQL servers, Access databases, and even text files.  I have even heard of attaching DB-400 through Client Access.

Somebody asked about multiples.  Yes you can. 



ATB

Charles Kincaid

Post #372397
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse