SQL Server Administration - User/Login Admin

Grant Database Access

Revoke a SQL Server Login. Note Microsoft states that this stored procedure will be deprecated and replaced by "Drop User"

Syntax - SQL Server 2005/2008

sp_revokedbaccess [ @name_in_db = ] 'name'

--returns 0=ok 1=failed

Example - SQL Server 2005/2008

EXEC sp_revokedbaccess  'SEASVR\ericm', 'ericm'
 Collapse All    Expand All
Custom Search

SQL Server Information and Resources