Linked Servers in SQL Server
The text of this article is not in this database — only its details are. Read it on the old site: Linked Servers in SQL Server
11 Comments
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment.
Suraj SorenPosted May 14, 2020, 6:27 AM
I was looking for this for a long time finally got this, very nice article.
Sr KarthigaPosted Jul 7, 2016, 6:45 AM
Nice explanation
Sr KarthigaPosted Jul 7, 2016, 6:44 AM
Good one
Madiha ZaibPosted Jan 28, 2013, 1:08 AM
Hello , Please Help me , I am using Access as the Linked Server in sql 2008, i want to update the record as using the query : UPDATE OPENQUERY([ACCESSDB],'Select [Phone2] from [Clients] where [Clientscode]=''ABL01''') SET [Phone2] = '12345678' but it will generate the error as: OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ACCESSDB" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ACCESSDB" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Msg 7320, Level 16, State 2, Line 1 Cannot execute the query "Select [Phone2] from [Clients] where [Clientscode]='ABL01'" against OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ACCESSDB". The provider could not support an interface required for the UPDATE/DELETE/INSERT statements.The provider indicates that conflicts occurred with other properties or requirements. Please Help Me......
Suresh SankarPosted Jan 21, 2013, 8:29 AM
Nice article...could that be possible to update the XML column through Linked server concept? for instance... UPDATE OPENQUERY ([serverA],'SELECT sSummarized,cast(xmlXtra as varchar)xmlXtra <DBNAME>.dbo.<TABLENAME> WHERE sSummarized IS NULL') SET sSummarized='DONE',xmlXtra = '<XmlXtra Complete = "DONE"/>'
sandeep beditedPosted Nov 23, 2012, 4:09 AMEdited Nov 23, 2012, 4:10 AM
Nice Article..Really good one..
Lajapathy ArunPosted Jun 23, 2012, 3:40 PM
Nice, looks like advance article. Happy to see new things :)
AndrewPosted Aug 1, 2011, 12:18 AM
It's very good article and the presentation is nice too.
Dea SaddlerPosted Jul 27, 2011, 2:22 AM
Helpful Article