Microsoft SQL Server 2000 Best Practices
The following scripts demonstrates the removal of a login with Windows authentication:
USE master
EXEC sp_revokelogin 'FinanceNET\jsmith'
