SnapshotGenerationAgent.RowDelimiter Property

Gets or sets the character or character sequence that marks the end of a row in the SQL Server bulk-copy data file.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Replication (in Microsoft.SqlServer.Replication.dll)

Syntax

'Declaration
Public Property RowDelimiter As String 
    Get 
    Set
'Usage
Dim instance As SnapshotGenerationAgent 
Dim value As String 

value = instance.RowDelimiter

instance.RowDelimiter = value
public string RowDelimiter { get; set; }
public:
virtual property String^ RowDelimiter {
    String^ get () sealed;
    void set (String^ value) sealed;
}
abstract RowDelimiter : string with get, set 
override RowDelimiter : string with get, set
final function get RowDelimiter () : String 
final function set RowDelimiter (value : String)

Property Value

Type: String
A String value that represents the row delimiter.

Implements

ISnapshotGenerationAgent.RowDelimiter

Remarks

When the RowDelimiter property is set to nulla null reference (Nothing in Visual Basic) or an empty string value, the default delimiter \n<x$3>\n is used.

When setting RowDelimiter, it is important to choose a delimiter value that will never be included in part of any published data value or else there will be ambiguity as to where data is delimited when the generated bcp file is applied to the Subscriber.

See Also

Reference

SnapshotGenerationAgent Class

Microsoft.SqlServer.Replication Namespace