Post reply

logins

  • July 9, 2009 at 1:19 am

    #134169

    Iam new to production

    why and how to disable a login in sql . explain

    thanks

  • July 9, 2009 at 1:37 am

    #1022185

    Look up ALTER LOGIN in Books Online

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 9, 2009 at 2:10 am

    #1022205

    You can also do this from ssms. Security--->logins--->choose login--->rightclick--->properties----> Disabled

    -MJ
    Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.

  • July 9, 2009 at 2:10 am

    #1022206

    You can also do this from ssms. Security--->logins--->choose login--->rightclick--->properties----> Disabled

    -MJ
    Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.

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

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