Is it possible to include a script in the uncompressed resx package1 file that will create a procedure on the master database and then also script the remainder of the procedures and data to the intended new target database? Also i would like to append scripted scheduled jobs that are written to the msdb database. Can I achieve this by simply editing the package1.resx file with each line of the orphaned database statement and laboriously ammend the batch numbers of the data elements and re-total the batch numbers?
If this is possible i.e. using USE [master], USE [msdb] & GO statements to target these orphaned databases, does anyone know of a simple method of renumbering the Batch numbers?