Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17

Thread: moving database to new server

  1. #16
    Join Date
    Sep 2002
    Posts
    5,938
    Dts copy logins task works as well.

  2. #17
    Join Date
    Aug 2006
    Posts
    27
    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
  •