Post reply

how lock the login on sql server 2000-sp4

  • August 13, 2010 at 11:40 am

    #222586

    Hi,

    If you know someway to lock the login running on SQL Server 2000 - sp4, please, let me know.

    Thanks,

    Sergio

  • August 13, 2010 at 2:46 pm

    #1206937

    In the past, I had wanted to do the same thing as well. To the best of my knowledge, this cannot be done in SQL 2000. If I'm incorrect, someone please correct me.

    Cindy

  • August 14, 2010 at 6:30 am

    #1207034

    Locking a login feature is not available in SQL Server 2000. Alternatively you can DENY LOGIN permissions for that login.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 3 posts - 1 through 2 (of 2 total)

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