SQL-DMO
Object Scripting Constants (SQLDMO_SCRIPT2_TYPE)
Object scripting constants are used by objects and methods that generate a Transact-SQL script as part of an administrative task automated using SQL-DMO. For example, object scripting constants are used to control the behavior of the:
- Script method of objects that reference Microsoft® SQL Server™ database objects, agent, and replication components.
- Transfer object when using the object to copy database objects and agent components.
- ScriptDestinationObject method of article objects that define replicated data.
Object scripting constants are used in the context established by the object or method. For more information about object scripting constant context, see the reference for the object or method.
| Constant | Value | Description |
|---|---|---|
| SQLDMOScript2_70Only | 16777216 | Disable features available in instances of SQL Server so that output is compatible with an instance of SQL Server version 7.0. Disabled features are:
Column-level collation |
| SQLDMOScript2_AgentAlertJob | 2048 | Generate Transact-SQL script creating SQL Server Agent jobs and alerts. |
| SQLDMOScript2_AgentNotify | 1024 | When scripting an alert, generate script creating notifications for the alert. |
| SQLDMOScript2_AnsiFile | 2 | Generated script file uses multibyte characters. Code page 1252 is used to determine character meaning. |
| SQLDMOScript2_AnsiPadding | 1 | Generate Transact-SQL SET ANSI_PADDING ON and SET ANSI_PADDDING OFF statements before and after CREATE TABLE statements in the generated script. Applies only when scripting references a SQL Server table. |
| SQLDMOScript2_Default | 0 | No scripting options specified. |
| SQLDMOScript2_EncryptPWD | 128 | Encrypt passwords with script. When specified, SQLDMOScript2_UnicodeFile must also be specified. |
| SQLDMOScript2_ExtendedOnly | 67108864 | Ignore all SQLDMO_SCRIPT_TYPE settings. Use to script extended property settings only. Script may require editing prior to running on destination database. |
| SQLDMOScript2_ExtendedProperty | 4194304 | Include extended property scripting as part of object scripting. |
| SQLDMOScript2_FullTextCat | 2097152 | Command batch includes Transact-SQL statements creating Microsoft Search full-text catalogs. |
| SQLDMOScript2_FullTextIndex | 524288 | Generated script includes statements defining Microsoft Search full-text indexing. Applies only when scripting references a SQL Server table. Include security identifiers for logons scripted. |
| SQLDMOScript2_JobDisable | 33554432 | Disable the job at the end of script creation. SQLDMOScript2_PrimaryObject must also be specified. |
| SQLDMOScript2_LoginSID | 8192 | Include security identifiers for logins scripted. |
| SQLDMOScript2_MarkTriggers | 32 | Generated script creates replication implementing triggers as system objects. Reserved for scripting replication articles. |
| SQLDMOScript2_NoCollation | 8388608 | Do not script the collation clause if source is an instance of SQL Server version 7.0 or later. The default is to generate collation. |
| SQLDMOScript2_NoFG | 16 | Generated script does not include 'ON <filegroup>' clause directing filegroup use. Applies only when scripting references a SQL Server table. |
| SQLDMOScript2_NonStop | 8 | If error occurs during script file generation, log error and continue. Applies when using object and collection Script method only. Reserved for SQL Server utilities. |
| SQLDMOScript2_NoWhatIfIndexes | 512 | Do not script hypothetical indexes used to implement the CREATE STATISTICS statement. Applies only when scripting references a SQL Server table. |
| SQLDMOScript2_OnlyUserTriggers | 64 | Generated script includes Transact-SQL creating user-defined triggers only. Reserved for scripting replication articles. |
| SQLDMOScript2_SeparateXPs | 256 | Script generation creates a second script file defining drop and create of extended stored procedures. Applies only when scripting stored procedures. Reserved for SQL Server utilities. |
| SQLDMOScript2_UnicodeFile | 4 | Generated script output file is a Unicode-character text file. |
See Also
Object Scripting Constants (SQLDMO_SCRIPT_TYPE)