Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_validatelogins (Transact-SQL)

Reports information about Windows users and groups that are mapped to SQL Server principals but no longer exist in the Windows environment.

Topic link icon Transact-SQL Syntax Conventions


sp_validatelogins

0 (success) or 1 (failure)

Column name Data type Description

SID

varbinary(85)

Windows security identifier (SID) of the Windows user or group.

NT Login

sysname

Name of the Windows user or group.

If the orphaned server-level principal owns a database user, the database user must be removed before the orphaned server principal can be removed. To remove a database user, use DROP USER. If the server-level principal owns securables in the database, ownership of the securables must be transferred or they must be dropped. To transfer ownership of database securables, use ALTER AUTHORIZATION.

To remove mappings to Windows users and groups that no longer exist, use DROP LOGIN.

Requires membership in the sysadmin or securityadmin fixed server role.

The following example displays the Windows users and groups that no longer exist but are still granted access to an instance of SQL Server.

EXEC sp_validatelogins
GO
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.