xp_revokelogin

Transact-SQL Reference

Transact-SQL Reference

xp_revokelogin

Revokes access from a Microsoft® Windows NT® group or user to Microsoft SQL Server™. xp_revokelogin is provided for backward compatibility. Use sp_revokelogin.

Syntax

xp_revokelogin {[@loginame =] 'login'}

Arguments

[@loginame =] 'login'

Is the name of the Windows NT user or group to be revoked access. The Windows NT user or group must be qualified with a Windows NT domain name. login is sysname, with no default.

Return Code Values

0 (success) or 1 (failure)

Remarks

xp_revokelogin is now a system stored procedure rather than an extended stored procedure and calls sp_revokelogin to revoke access to SQL Server for a Windows NT group or user.

See Also

sp_denylogin

sp_grantlogin

sp_revokelogin

System Stored Procedures (General Extended Procedures)

xp_loginconfig

xp_logininfo