Can anybody please, let me know that how can we disable a login in SQL Server 2000.
+2
A:
Depends on exactly what you're after. But the simple SQL to disable a user is:
ALTER LOGIN [MyUser] DISABLE
Robin Day
2009-03-03 18:36:34
Not on SQL Server 2000. Who voted up for wrong answer?
gbn
2009-05-15 04:32:14
+1
A:
In SQL Server 2000, you can use sp_denylogin to deny NT logins/groups access. You can only drop SQL logins.
SQL Server 2005 +, things changed.
gbn
2009-05-15 04:32:50