DMVs Waits Cookbook Scripts XEvents SPs Catalog Functions Errors T-SQL Arch Ops

sys.sp_revokelogin

general
#stored-procedure

Description

Removes the login entries from SQL Server for a Windows user or group created by using The name of the Windows user or group. , with no default.

Syntax

<ComputerName>\<User>

Remarks

Removes the login entries from SQL Server for a Windows user or group created by using

The name of the Windows user or group.

, with no default.

can be any existing Windows user name or group in the form

(success) or

This feature will be removed in a future version of SQL Server. Avoid using this feature in

new development work, and plan to modify applications that currently use this feature.

Examples

Example 1

sp_revokelogin

Example 2

ADVWORKS\john

Example 3

ADVWORKS\Admins

Example 4

sp_revokelogin

Example 5

ADVWORKS\john

Example 6

ADVWORKS\john

Example 7

ADVWORKS\Admins

Example 8

ADVWORKS\Admins

Example 9

ADVWORKS\john

Example 10

ADVWORKS\john

(. and 30 more examples)