-
Dts copy logins task works as well.
-
thx Rainbow river and rmiao..
yea.. DTS for logon name. that's what i use to transfer user after i restored the database in new server. but only transfer over the user.. not the permission. everyone is same. but like you said. sp_change_users_login did job done.. but some of the login name under security suppose to be sa still need to manually modify.. but with is sp.. it is much easier.. i use
select 'exec sp_change_users_login' + '''auto_fix'', ''' + name + ''', '+ 'null' from sysusers where status <>0 and uid not in ('1', '2')
to list up the script with all user in that database and run them.. so i dont have to type one by one..
but really.. thanks guys.
Last edited by a5718800; 11-02-2006 at 04:16 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|