TransArticle.SetColumnDestinationDataType Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Sets the column data type mapping for a non-SQL Server Publisher.
public:
void SetColumnDestinationDataType(System::String ^ columnName, System::String ^ dataType, long precision, int scale, long length);
public void SetColumnDestinationDataType (string columnName, string dataType, long precision, int scale, long length);
member this.SetColumnDestinationDataType : string * string * int64 * int * int64 -> unit
Public Sub SetColumnDestinationDataType (columnName As String, dataType As String, precision As Long, scale As Integer, length As Long)
Parameters
- columnName
- String
A String value that specifies the name of the column for which the destination data type is changed.
- precision
- Int64
An Int32 value that specifies the precision of the data type. Set this parameter to -1 if it does not apply to the specified data type.
- scale
- Int32
An Int32 value that specifies the scale of the data type. Set this parameter to -1 if it does not apply to the specified data type.
- length
- Int64
An Int32 value that specifies the length of the data type. Set this parameter to -1 if it does not apply to the specified data type.
Remarks
The SetColumnDestinationDataType method is only supported for non-SQL Server Publishers.
The SetColumnDestinationDataType method can only be called by members of the sysadmin
fixed server role at the Distributor or by members of the db_owner
fixed database role on the database.
Calling SetColumnDestinationDataType is equivalent to executing sp_changearticlecolumndatatype.