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.