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 |
|
sponguru_dba
Yak Posting Veteran
93 Posts |
 Posted - 2007-11-01 : 10:22:10
|
| Hiafter moving Database one server other server,there will be problems with Orphan user,so that we are using "sp_change_users_login" Proc to fix users.what that mean "sp_change_users_login" is going to change the user or going to remove the users.SreenivasaRaoPune,INDIA |
|
|
sponguru_dba
Yak Posting Veteran
93 Posts |
Posted - 2007-11-01 : 10:38:31
|
| Hi KristenPlease help regsSreenivasaRaoPune,INDIA |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2007-11-01 : 22:49:44
|
| Hi SreenivasaRao, What that sp do is to map the user existing in the current database to the login on the server, it simple creates the link for the sid, so it does not remove or create any new users. Hope this help. |
|
|
|
|
|
|
"sp_change_users_login" what is Proc will do