Linked Server to its self?

[aljubicic]

Hi,

I am cuurently setting up an environment at home to mimic the setup at work, which is comprised of an application connected to a SQL Server. Now this SQL Server has linked Servers setup to other servers for Data transactions using triggers. Since I have only one SQL Server setup at home I was hoping to create 2 Linked Servers that just points to itself to a database that mimics the databases on the other servers at work. Is this possible and how would I configure it using SQLOLEDB or other?

Can someone please give me some direction.

Thanks
Anthony

 

[mrdenny]

Set up the linked servers just like you would if you were going to another server, just in the server name put the local servers name instead of the remote servers name.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com