Script2Type Property

아티클
12/15/2008

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

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.

구문

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.

주의

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.