Home Forums Programming Powershell SQL Logins output to a file via sp_help_revlogin RE: SQL Logins output to a file via sp_help_revlogin
ali zulu
SSC Enthusiast
Points: 117
More actions
January 29, 2015 at 3:16 am
#1773923
Brilliant,
I created script that collects this information from all my Production SQL servers and stores it in a central database table. This uses a linked-server to loop through all my SQL servers once a day via a scheduled SQL job.