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.

Recommended Answers

All 2 Replies

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 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.