SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)


By Chad Miller,

Perl script that reports SQL Server AD accounts which are now longer valid by verifying the output of sp_validlogins system stored procedure against SID stored in AD. This is done to ensure only accounts that do not exist are reported since sp_validlogins will only check the name and not SID against AD. Accounts that are renamed will retain the same SID, resulting in false positives.

Total article views: 238 | Views in the last 30 days: 3
Related Articles

service account

Service account


Creating accounts using SSIS ???

ADSI accounts


Windows account

describe a windows account


cancel account

how do you cancel account


Proxy Account

How to create proxy account.