Script SQL Database DDL News
Brought to you by:
rvsutherland
A new program named ScriptAllDBs.exe has been added to the
project. The program is a simple wrapper which calls
ScriptDB.exe for each non-system database in the specfied
server.
Among the improvements in Release 1.04 are:
a. Files are now ASCII, not Unicode.
b. Scripting permissions for SQL Server 2000 databases
has been changed. SQL-SMO was scripting table and
view permissions at the column level, even when they
were granted at the table/view level. This has been
corrected by custom coding the permissions on tables
and views.
Users of earlier versions may want to consider re-scripting
some databases to take advantage of these improvements.