Search

Wednesday, February 27, 2013

To find all logins that have been disabled in SQL 2005/2008/2008R2

select name,* from sys.server_principals where is_disabled = '1'

No comments:

Post a Comment