Post reply

Drop Login

  • June 4, 2008 at 11:11 am

    #122581

    Hello All

    I want to write a stored procedure that will drop a login. But first, I want to check to see if it exists. What is the table name that I query to get the logins?

    Thanks in advance for your help

    Andrew SQLDBA

  • June 4, 2008 at 11:19 am

    #824364

    sys.syslogins

    Susantha

  • June 4, 2008 at 11:23 am

    #824368

    Thank You

    I could not think of that. Maybe it was too simple or something.

    Feels like a monday after a long weekend. My brain is not working clearly

    Thanks again

    Andrew SQLDBA

  • June 4, 2008 at 11:26 am

    #824369

    What about the Users in a specific database? What table are they stored in?

    I am seeing a user that is in a database that I just restored. I need to drop that user account

    Thanks

    Andrew SQLDBA

  • June 4, 2008 at 11:29 am

    #824371

    sys.sysusers

    Susantha

Viewing 5 posts - 1 through 4 (of 4 total)

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