...I'd be using Red Gate's SQL Multi Script. The initial "alpha" version is available now for free. I've given it a whirl and it works exactly as advertised, with further improvements in the pipeline too.
At first glance I thought a utility like this would be better off being built into SQL Server Management Studio. After using it (and reading on the forum what other users want it for), I reckon a small, stand-alone product is probably better.
I've been advised that this alpha release will stop working at the end of 2007.
Tags: 
sql server, 
database, 
script, 
server
posted @ Thursday, September 13, 2007 11:32 PM