Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tcronin@cmsstl.com
Starting Member
7 Posts |
 Posted - 2012-11-05 : 14:11:50
|
| I have to migrate to a new server and domain. I have serveral servers which have links to this server. I did the linked server with the server name (maybe not the best), but for the developers they liked the idea that the link gave them access to all the read-only database objects they needed. I realize you could do the other way of having an oledb source for each catalog(database) but this would have required a catalog/link for each database ( Ihave 6 db's that need to be exposed). ANy better approaches? |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-11-05 : 18:35:07
|
| Your approach of using the linked server would be the approach that I would use; especially since the data is read_only.=================================================We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry |
 |
|
|
|
|
|
linked servers