Find Orphaned AD Logins using sp_validatelogins

One of my favorite new features for SQL 2008 is the ability to run commands against all your registered instances immediately. For me that saves time as I have over 150 instances (and growing). The other day I was reading Tim Ford’s blog entry about xp_logininfo which led to an exchange of emails between Tim … Read more