Setting the database options for a New Database
Published 08 February 2013
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.