SQL Server Object script generation to individual files?
I'm using SQLServer 2005 Express (for development but also have access to same DB on a 2008 Enterprise server)
I'm looking for a way to script every object in the database - with output going to individually named files. Is this possible? I see the Generate Scripts option but it dumps everything into a single file.
I'd like multiple files, named as the object name, so that I can start putting them all under revision control.
Perhaps somebody has a script that will perform this task?