Member Avatar for mokong

Hi All,

I am trying to link two database in different servers. Are there any ways I can do this?
If this possible, could anyone show me how to do it. I've been googling it a few weeks ago, there are sites that said to use the sp_addlinkedserver but I don't know how to use it.

A detailed explaination is very much apprciated.

Thank you.

Edited by pritaeas because: Moved
  • 3 Contributors
  • 2 Replies
  • 139 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by JorgeM
Member Avatar for JorgeM

You can either use the stored procecudure you referenced or use hte GUI in SQL Management Studio to create the linked server.

Once you create this object, you can reference the remote SQL database in your Queries, by specifying the linked server in your statement.

For example...

select * from remoteSQLServer.databaseName.dbo.tableName

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.