Linked SQLServer
Home > IT Answers > SQL Server > Linked SQLServer
Db23
230 pts.
0
Q:
Linked SQLServer
Linked SQL Servers, SQL Server Linked Server, SQL Server 2005, SQL Server database
Hi,

In oracle database you are able to link the oracle database to a SQLServer 2005 database, I want to be able to link a SQLServer 2005 another SQLServer 2005 database (not another SQLServer 2005), does SQLServer 2005 allow us to do this? Does it only allow server to server linking?

Thanks.
ASKED: Apr 27 2009  10:49 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Flyght
55 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
If they are on the same server and same database instance then you can just reference the database by using ... [DatabaseName].[DatabaseOwner].[TableName]

If it is on another server then you will need to link the servers.

To the best of my knowledge, and I am not a SQL expert, I think SQL Server may treat different SQL instances as different Servers even if they are on the same physical server, that should be in the help files.

Hope this helps.
Last Answered: Apr 27 2009  9:37 PM GMT by Flyght   55 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Alessandro Panzetta   0 pts.  |   Apr 27 2009  12:00PM GMT

As far as I know you can “attach” the database but not link it.

 

mrdenny   46795 pts.  |   Apr 27 2009  10:28PM GMT

Different instances are treated as separate servers when it comes to linked servers. Instances are independent of each other and know nothing of each other unless a linked server is created from one to another.
If they are within the same instance then simply access the database via the three part name as shown above.

 
0