Results 1 to 2 of 2

Thread: After the restore, db users doesn't show up

  1. #1
    Guru Guest

    After the restore, db users doesn't show up


    Hi,

    After doing a database restore on my development server, It only shows DBO As the db user..When I query SYSUSER all other users are still there..But doesn't show up in enterprise manager...

    Anybody came acrosss the same situation ?

    Thanks for you help in advance.

  2. #2
    Ray Miao Guest

    After the restore, db users doesn't show up (reply)

    You can fix this with sp_change_users_login.


    ------------
    Guru at 5/28/2002 11:58:15 AM


    Hi,

    After doing a database restore on my development server, It only shows DBO As the db user..When I query SYSUSER all other users are still there..But doesn't show up in enterprise manager...

    Anybody came acrosss the same situation ?

    Thanks for you help in advance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •