in

SQL Server Community Blogs

Voices of the SQL Server Community
All Tags » Linked Server (RSS)

Browse by Tags

  • Linked Server timeouts

    I had a puzzling little problem this week which caused our remote users unable to access our system in our remote location. We have two SQL Server 2005 SP2 servers on different continents. The link between them is extremely slow around 100kbit. We have a linked server set up on the remote server, let...
    Posted to Mark's SQL Server Blog (Weblog) by MarkAllison on 01-29-2008

  • a question

    Boss told you to come up with a question to test new programmers? Here's one: you have a linked server and an openquery statement. What is the number returned by this query? select count(*) from openquery(LINKED_SQL, 'select count(*) from database.dbo.table1')
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on 01-23-2008

  • distributed transactions and triggers

    Last week I came across an interesting issue. If you have a FOR INSERT trigger on a table and you want to store some information on a linked server, the transaction the trigger is running within is automatically expanded to distributed mode. This creates some problems. First, you have to have Distributed...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on 10-29-2007

  • Dynamic ORACLE SP for calling a linked server database environment based on a parameter.

    I haven't posted anything here yet on this blog, so I thought I'd pull some lesson I learned a while back and use it as a post. If it helps you; great, if not, no worries. The problem I tried to solve involved 5 or 6 Oracle environments that need to have data pulled from them into SQL Server. The user...
    Posted to greenmtnsun (Weblog) by greenmtnsun on 08-27-2007
Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems