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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Apr 4, 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

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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


















Thanks for your registration, follow us on our social networks to keep up-to-date