I am trying to write a sp that our support staff can use that will dynamically create a bunch of insert statements into a .sql file.
Is there an easy way to do this? I basically need for our support staff to run this stored proc, which will pull configuration data from our database and store the configurations within insert statements to use later. The purpose is to be able to save configurations and be able to reload DBs without losing the configs.
I have already created the script, but I am trying to make it as simple as possible so that they run the sp and it saves the config on their hard drives in a folder. Thanks.