Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    1

    Unanswered: sp_change_users_login

    Could someone give me an example of how to use this stored procedure. I moved a database from one server to another and now the logins do not work.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Check BOL. Also, open it in EM and copy the actual SELECT that pertains to you. This way you will not be limited by @@trancount when trying to script "update_one" for many accounts.

Posting Permissions

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