I would like to create a T-sql script and scheduled. My goal is create all my databases (4 databases) and when the QA or DEV team need to test something, they can use these databases. The problem is that I don´t have other server so I have to use the same server, for example I have a database called AUXDB, so I need to create a new database as PRE_AUXDB. I have been creating all the scripts per each dabatase (just structure) but I need to know, how to create a header script to execute each script. I hope you can understand my request.
Thank you in advance. Raúl