SourceTranslateChar Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The SourceTranslateChar property specifies whether to perform character data translation on the source server during a transfer operation.
Syntax
object
.SourceTranslateChar [= value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetSourceTranslateChar(LPBOOL pRetVal);
HRESULT SetSourceTranslateChar(BOOL NewValue);
Remarks
Performing character data translation during a transfer operation can significantly impact server performance if a large amount of data must be translated. The SourceTranslateChar property is set to TRUE by default.
Set the DestTranslateChar property to TRUE to perform character translation on the destination server.
Set SourceTranslateChar to TRUE to resume character translation on the source server.