Hi,
I'm using MsSql 2000 data base, how to enable and disable user in mssql 2000 version
From BOL:
sp_revokelogin disables connections using the account specified by the login parameter. But Windows users that have been granted access to an instance of SQL Server through membership in a Windows group can still connect as the group after their individual access has been revoked. Similarly, if the login parameter specifies the name of a Windows group, members of that group that have been separately granted access to the instance of SQL Server will still be able to connect.
HTH,
-Steven Gott
SDE/T
SQL Server
