samedi 3 janvier 2015

How can i get the expired sql login accounts in sql server 2005/2008R2?


Per our Audit, there is a requirement where we need to pull out the list of sql login accounts created date and there expiration as well. If manually i go about checking i can see that option, but is there a faster way where i can use the script and list that out for all of my sql servers, having expired or going to expired sql login accounts?





Aucun commentaire:

Enregistrer un commentaire