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 |
|
Richard Branson
Yak Posting Veteran
84 Posts |
 Posted - 2004-01-22 : 04:49:17
|
| I have a stored procedure in database A accessing data from database B in the same server.Database B is about to be moved to another server.since execute permissions to sp_addlinkedserver default to members of the sysadmin role, how will the clients access the data in database B? thank you.You can't teach an old mouse new clicks. |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-01-22 : 05:24:16
|
| You add the linked server under your sysadmin role once, then the clients access this server under the login credentials you have specified. The stored proc shouldn't add the link server itself, you do it.Raymond |
 |
|
|
|
|
|
Linked servers