While developing a new db and changing the schema, I keep clobbering dependent objects, like existing views, procedures, triggers, etc. So I want to create a set of .sql script files, one for each database object, and keep them in separate Windows folders (one for procedures, one for functions, etc.). I want each folder to have one file containing the names of all the script files in that folder, and to be able to "invoke" that one file to execute all the individual scripts named in it. Finally, I'd like to have one "master" file that invokves all the individual sub-files, so I can recompile the world by invoking one file. Note that I DON'T want to put all the database objects in one gigantic script file. The key is being able to invoke files from files, nesting them. I did this years ago in Oracle; is there a way to do this in SQL Server (2005)?