The UseCollation property specifies whether column-level collation settings on the source table are used when transferring data between computers running instances of Microsoft® SQL Server™ 2000.
transfobj.UseCollation [= value]
| Part | Description |
|---|---|
| transfobj | Expression that evaluates to a TransferObjectsTask2 object. |
| value | Determines whether column-level collation settings are used when transferring data. |
Boolean
Read/write
HRESULT GetUseCollation(VARIANT_BOOL *pRetVal);
HRESULT SetUseCollation(VARIANT_BOOL NewValue);
The default for this property is TRUE. The UseCollation property of the TransferObjectsTask2 object exposes the UseCollation property of the SQL-DMO Transfer2 object.
If UseCollation is set to TRUE and the destination table is dropped during transfer, the new destination table will be created with column-level collations identical to those of the source table.
If UseCollation is set to FALSE and the destination table is dropped during transfer, the new destination table will be created with column-level collations identical to those of the destination server default code page. Note that if the column-level collation of the source data does not match the source server default code page, mistranslation will occur.