Linked SQLServer

290 pts.
Tags:
Linked SQL Servers
SQL Server 2005
SQL Server database
SQL Server Linked Server
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Db23
    As far as I know you can "attach" the database but not link it.
    0 pointsBadges:
    report
  • Denny Cherry
    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.
    66,185 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following