I have four scripts that use metadata and PRINT commands to create scripts that perform alterations on a database schema and data.
Currently the output is going to a message window, i am cutting and pasting into a new query and running the result.
I would like to have each "creation" script put its output into a new script.
The goal is to consolidate the four "creation" scripts into one, and have each of the four batches within that script create its own .sql file ( the name and location would remain fixed with automatic overwrite ) and then to run those four scripts in sequence.
I see that I can point the results of a query to file rather than the message window but don't see how to do that programmatically in T-SQL
As always, guidance appreciated.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.