Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    100

    Exclamation Unanswered: Just checking! sp_change_users_login

    Hi I just wanted to quickly check that this does what I think it does, and has no nasty side effects.


    I'm using the sp_change_users_login with the @Action = Update_one to change the Login name on a user, it seems to work but I'm a little confused by the help file and just wanted to know I haven't done anything really stupid.

    It come back with the message:

    The number of orphaned users fixed by updating users was 0.

    which sounds good, I would want to orphane any of our users!

    Thanks Nixies!

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    No, it's just saying that it couldn't find any to fix....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jul 2003
    Posts
    100

    Talking

    Brill, I can sleep again , thanks Nixies

Posting Permissions

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