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

    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
    San Antonio, TX
    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