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 |
|
jhunu
Starting Member
18 Posts |
 Posted - 2011-11-25 : 13:58:14
|
| Long back ago , the linked servers was created in the server. Now the Database name has been changed from BSE to BSEDB. This same changes need to be applied in Linked server. How to change the properties in linked server without deleting in ? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-25 : 14:01:41
|
| Depends on the type of link - could be the datasource or maybe the default database on the destination.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-25 : 14:21:53
|
| you drop and recreate the link server.. |
|
|
|
|
|
|
LInked Server proeprty