Disable and Enable logins

  • How do I disable or enable Logins in sql server 2000 sp2 standard edition.

  • If it's a Windows login, you can use sp_denylogin and sp_grantlogin or you can do it in Enterprise Manager by checking "Deny access" or "Grant access" in the login properties. If it's SQL Server login, you have to drop it or change it's password to prevent connection.

    Greg

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

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