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 |
|
paydogg
Starting Member
1 Post |
 Posted - 2009-09-29 : 03:37:55
|
| Hopefully someone can bring some light to my problem.I am in a development team using, asp vb6 and sql 2005 and we have the following problem.I am a newbee to Link Servers and this forum is coming pretty handy to get started, so thanks everyone for the info.Up to the moment we have been using one sql server containing all the DB of our proyects but now we are changing to linked servers. The problem is that we are going to have to change all the Stored Procedures of all our databases, where we had DB.Table we´ll have to change it to Server.DB.Table which really is going to be a lot of work, so I am trying to find a way of doing this that doesn´t imply changing by hand every single SP, considering also that the location of a particular database may change from time to time and we´ll have to do the same operation more times.Any ideas would be nice,Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-29 : 06:21:05
|
| sorry i didnt understand reason behind going 4 linked servers. your explanation sounds like simple db migration but why go for linked server? can you explain that part? |
 |
|
|
|
|
|
Migrating to a different sql Machine-linked server