June 9, 2014 at 6:37 pm
I would like to create a job to run the dbo.sp_help_logins stored procedure. This would create an updated file to store with D.R. scripts. I am not a developer... Has anyone created a method like this?
Thank you in advance!
Charlie
June 10, 2014 at 6:26 am
I've done this in the past. I created a SQL Server Agent job with one step that had the command "EXEC sp_help_revlogin" in the database master. One the Advanced page for the job step specify an Output file. Just make sure that this location is available in a DR situation. I scheduled the job to run daily.
June 10, 2014 at 6:27 am
There is more information on the sp_help_revlogin here http://support.microsoft.com/kb/918992/en-gb
June 10, 2014 at 10:02 am
Thank you very much!
Charlie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply