Post reply

who is sysadmin

  • March 20, 2018 at 2:15 pm

    #1984040

    Perry Whittle - Tuesday, March 20, 2018 2:02 PM

    Ahh in place upgrade may be different, logins wont be deleted during this.Windows admins can only add this login if they know how to start the instance single user and know the tsql cmds to achieve this.New installs do not create builtin\admibistrators login

    Ok... I don't feel so bad now.  Thanks, Perry.  Still, I have to figure out what happened when we did the new install when we went from 2005 to 2012.  I was pretty sure that I deleted that from the ol' sp_RevLogin script that we generated from the old box.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing post 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply