Get databasename for a particular user

  • Hi all, I have a username I need to script and replicate to UAT, but no indication of which DB - any idea where this is?

    TIA

  • Never mind 🙂

  • JackCarrington - Monday, September 3, 2018 9:47 AM

    Never mind 🙂

    Please share what caused you to say "Never Mind".  What did you find out?

    --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)

  • Jeff Moden - Monday, September 3, 2018 8:01 PM

    JackCarrington - Monday, September 3, 2018 9:47 AM

    Never mind 🙂

    Please share what caused you to say "Never Mind".  What did you find out?

    Almost too embarrassing to recount...there was a login by the same name, so of course I double clicked it and found the users 🙂

    (cringe) - definitely a brain fart moment !!

  • JackCarrington - Tuesday, September 4, 2018 5:10 AM

    Jeff Moden - Monday, September 3, 2018 8:01 PM

    JackCarrington - Monday, September 3, 2018 9:47 AM

    Never mind 🙂

    Please share what caused you to say "Never Mind".  What did you find out?

    Almost too embarrassing to recount...there was a login by the same name, so of course I double clicked it and found the users 🙂

    (cringe) - definitely a brain fart moment !!

    Heh.. thanks for the feedback.  The rest of us are just as human. 😀

    --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 5 posts - 1 through 4 (of 4 total)

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