How do I link 2 sql server databases?
Posted on 2006-10-30
I have two servers both windows 2003 and running sql server 2005. Each server has one database in it and I would like to know how I get a link table (or something similar) on server1 to a table on server2 so that I can run views on server1 which will pull data from server2?
I've seen some info about sp_addlinkedserver but I don't know if that's what I want to use and if it is, how do I use it?
Thanks for any help you can give me.