Thanks for +ve comments,

Anyone interested in sample code of what we did, take a look here

http://www.mediafire.com/?eim2mydnjti

Disclaimered as you'd expect.

Regarding the ongoing debate about "proper" source control usage, I...

I think it was a useful article and it's certainly sparked off a lively and fascinating debate.

haha- sorry didn't realise grasshopper was a forum participation level thing, sorry about that! 🙂

That all makes sense, although it's a shame you can't subcategorise scripts into different types...

Grasshopper,

Got a few questions about your SSMS approach -

-Is there anyway of categorising into different sorts of scripts (/subfolders?) Or do they all just end up under 'queries'?

-How...

I'm not sure I understand? How do you save a stored procedure is SSMS?

Do you mean by clicking on "modify" or "script as create to new query window" to...

I kept .dtsx and .rdl files out of this discussion -they already sit very naturally as files in a standard source repository. Obviously there's no point scripting them out...

The built-in generate scripts was where we started from - we just got tired of having to manually set the same parameters each time, and the fact that it is...

I personally haven't found a great deal of info on how to script objects using SMO which is why I think people end up doing slightly scary things like querying...

Automated deployments of stored-procs is relatively easy, but anything that involves a table schema change for example kind of makes the whole approach a bit complex and prone to problems....

I also had similar issues with sp_helptext and eventually found a way of scripting objects using

Microsoft.SqlServer.Management.Smo.Scripter in Powershell.. this has the advantage that it handles all types of objects including...