provides a tool called scptxfr which generates DROP and CREATE scripts
Editor: SQL Server 2000 provides a tool called scptxfr which generates DROP and Create scripts for all objects in a database.

Since it is not included in the latest SQL Server versions, I developed a replacement for scptxfr which uses the .Net SMO libraries for script generation called SMOscript.

The SMOscript utility implements the following functions:

* list all databases on a server
* list all objects in a database
* script CREATE or DROP Statements for each object in database you can free download SMOscript 0.10 now.