Mark Gilbert’s Blog

This is the home of my SQL Server Management Studio “Scripter”. 

The Scripter creates DROP and CREATE statements for Views, Stored Procedures, and User-Defined Functions in the same format as SQL Server 2000 Enterprise Manager (SSEM) did. SQL Server 2005 Management Studio (SSMS) changed how the scripts are generated, and you can no longer get the DROP and CREATE statements in a single script – you have to generate two different scripts, and then merge them together.

Additionally, the built-in scripting features of SSMS would add a comment line about each object scripted. While this doesn’t affect the quality of the script functionally, it tends to make it slightly more difficult to read.

The latest installation for the Scripter, as well as the past released versions of the source code, can be found here: http://CodePlex.com/SSMSScripter.

For more detailed information about the mechanics behind the Scripter, please see the following blog entries in this category: http://Mark-Gilbert.com/category/sql-server/.