Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Apr 5, 2002

Linked Servers - Page 4

By Neil Boyle

Loopback Linked Servers

You can set up a linked server to point to itself, but why would you want to?

One reason Microsoft cites is that you may only have one server to develop on, but need to test linked servers for a live environment with more than one server (See, you can try this at home!)

Loopback linked servers do come with a couple of drawbacks though--you cannot use them for Distributed Partitioned Views, and you cannot use them for nested transactions (which limits their potential for testing Update statements).

One other good reason for using Loopback Lined Servers is the Application Role. Once an Application Role has been started, you will not be able to directly access a different database on the same server, even if your Login ID has the necessary data rights. This is because the Application Role suspends all the rights associated with the login ID and replaces them with its own. However, you can still access Linked servers, so you can get at the other databases in this manner.

Note that although Network Traffic will not be an issue with Loopback Linked Servers, there are still processing overheads to deal with, as the server still has to initiate a new connection every time you access the Loopback Linked Server.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM