SSIS package to Create backup of Logins with Password. This package will works like backup of your login script with password. The script also generates script for server level roles. For this you need to create two procedures in master database. Step1 : Create supporting stored procedures in Master database. Script for “[DBO].[SP_HEXADECIMAL]“ Script for “[DBO].[SP_HELP_REVLOGIN]“ [...]
SSIS Package to Backup Jobs Script using SMO. This package willl use some SMO reference and generates SQL Server Jobs, Operators and Alerts script backup. I had written the code for SQL Server Jobs only and commented code for Operators backup and Alerts Backup. You just need to replcace Operators or Alerts instead of Jobs. [...]