Automate Generate Scripts Wizard In Sql2008

Problem: how to automate a Generate Scripts in SQL2008 Management Studio: ie right click on database, Tasks, Generate Scripts All Tables All Stored Procs Create drop statements Do

Solution 1:

Use SMO - it's the right thing to do and you know it!

Solution 2:

Have a look at DBSourceTools. http://dbsourcetools.codeplex.com It's an open-source scripting engine for SQL Server Databases that uses SMO.

Solution 3:

I've taken Will A's advice and tried scripting.. SQL Server Management Objects

nearly there :-)