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:
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. |
Object Scripting Constants (SQLDMO_SCRIPT_TYPE)