dcsimg
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 SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  

By submitting your information, you agree that databasejournal.com may send you databasejournal offers via email, phone and text message, as well as email offers about other products and services that databasejournal believes may be of interest to you. databasejournal will process your information in accordance with the Quinstreet Privacy Policy.

News Via RSS Feed


Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

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

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