Script2Type Property
Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.
The ScriptType and Script2Type properties configure the Transact-SQL script generated and used to copy database schema in a transfer of schema from one database to another.
Sintaxe
object.Script2Type [= value]
Parts
object
An expression that evaluates to an object in the Applies To list.value
A long integer that specifies script generation options as described in Settings.
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetScript2Type(SQLDMO_SCRIPT2_TYPE* pRetVal);
HRESULT SetScript2Type(SQLDMO_SCRIPT2_TYPE NewValue);
Settings
Constant |
Value |
Description |
|---|---|---|
SQLDMOScript2_70Only |
16777216 |
Disables features available in instances of SQL Server 2000 or later so that output is compatible with an instance of SQL Server version 7.0. Disabled features are: Column-level collation User-defined functionsExtended properties Instead of triggers on tables and views Indexes on views Indexes on computed columns Descending indexes The default value is OFF. |
SQLDMOScript2_AgentAlertJob |
2048 |
Generates Transact-SQL script creating SQL Server Agent jobs and alerts. |
SQLDMOScript2_AgentNotify |
1024 |
When scripting an alert, generates script creating notifications for the alert. |
SQLDMOScript2_AnsiFile |
2 |
The generated script file uses multibyte characters. Code page 1252 is used to determine character meaning. |
SQLDMOScript2_AnsiPadding |
1 |
Generates Transact-SQL SET ANSI_PADDING ON and SET ANSI_PADDDING OFF statements before and after CREATE TABLE statements in the generated script. It applies only when scripting references a SQL Server table. |
SQLDMOScript2_Default |
0 |
No scripting options are specified. |
SQLDMOScript2_EncryptPWD |
128 |
Encrypts passwords with script. If this setting is specified, SQLDMOScript2_UnicodeFile must be specified as well. |
SQLDMOScript2_ExtendedOnly |
67108864 |
Ignores all SQLDMO_SCRIPT_TYPE settings. Use to script extended property settings only. The script may require editing before it runs on the destination database. |
SQLDMOScript2_/ExtendedProperty |
4194304 |
Includes extended property scripting as part of object scripting. |
SQLDMOScript2_FullTextCat |
2097152 |
The command batch includes Transact-SQL statements creating Microsoft Search full-text catalogs. |
SQLDMOScript2_FullTextIndex |
524288 |
The generated script includes statements defining Microsoft Search full-text indexing. It applies only if scripting references a SQL Server table. It includes security identifiers for logons scripted. |
SQLDMOScript2_JobDisable |
33554432 |
Disables the job at the end of script creation. |
SQLDMOScript2_LoginSID |
8192 |
Includes security identifiers for logins scripted. |
SQLDMOScript2_NoCollation |
8388608 |
Does 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 |
The generated script does not include an 'ON <filegroup>' clause directing filegroup use. It applies only if scripting references a SQL Server table. |
SQLDMOScript2_/NoWhatIfIndexes |
512 |
Does not script hypothetical indexes used to implement the CREATE STATISTICS statement. It applies only if scripting references a SQL Server table. |
SQLDMOScript2_UnicodeFile |
4 |
The generated script output file is a Unicode-character text file. |
Comentários
Use the AddObject and AddObjectByName methods of the Transfer object to build a list of SQL Server components copied from one database to another. After the list is built, configure component transfer using the ScriptType and Script2Type properties.