SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

SnapshotGenerationAgent.FieldDelimiter Property

SQL Server 2005

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

Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Replication (in microsoft.sqlserver.replication.dll)
C#
C++
VB
Copy 
public string FieldDelimiter { get; set; }
J#
Copy 
/** @property */
public final String get_FieldDelimiter ()

/** @property */
public final void set_FieldDelimiter (String value)
JScript
Copy 
public final function get FieldDelimiter () : String

public final function set FieldDelimiter (value : String)

Property Value

A String value that represents the field delimiter.

When the FieldDelimiter property is set to null or an empty string value, the default delimiter \n<x$3>\n is used.

When setting FieldDelimiter, 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.


Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.