SQL Packager 7

Setting the database options for a New Database

When using SQL Packager to package a new database, you will notice that the databases are created with a default options set, rather than the same options as the source database. 

The default options used by SQL Packager for a new database are:

  • auto create statistics
  • auto update statistics

If you want to set options other than the default options, you can add them to PACKAGE_NEW_DBOPTIONS in PackageProperties.resx when you export the package as a C# project, using the built-in Visual Studio resource editor.

The options will need to be semi-colon separated, and only options that can be set through sp_dboption are valid. See http://msdn.microsoft.com/en-us/library/aa933268(v=sql.80).aspx for more details.


Didn't find what you were looking for?