Jaa


ProfileName Property (Replication)

The ProfileName property specifies the name of the merge agent profile at the Distributor to be used by the SQL Server 2005 Compact Edition (SQL Server Compact Edition) Subscriber. A profile defines behavior such as time-out values. You can override the default values by creating a profile on the Distributor and specifying its name by using ProfileName.

Syntax

object.ProfileName [= value]

Parameters

  • value
    Agent profile name

Applies To

SQL Server Compact Edition Replication object

Data Type

String

Modifiable

Read/write

Prototype

HRESULT get_ProfileName(BSTR *pVal);
HRESULT put_ProfileName(BSTR newVal);

Remarks

A profile contains a set of parameters that control the behavior of the SQL Server Reconciler. For example, the profile specifies the LoginTimeOut and QueryTimeOut values used by the SQL Server Reconciler. The profile is stored on the Distributor. The profile is read every time a subscription is synchronized. For more information, see "Agent Profiles" in SQL Server Books Online.

The profile lets you easily change key parameters for synchronization across all subscribers without having to change the values at each subscriber. For example, if you have five SQL Server Compact Edition clients that share a profile and you want to change the query time-out value for all of them, you just change the QueryTimeOut value in the profile, and then all SQL Server Compact Edition clients will use the new QueryTimeOut value.

You can also create different profiles for different SQL Server Compact Edition clients. For example, a SQL Server Compact Edition client that uses a dial-up Internet connection might use one time-out value, and a client that uses a high-speed intranet connection might use a different time-out value. ProfileName is used to specify the name of the profile.

If ProfileName is not specified, the default profile values are used.

If ProfileName is specified, the LoginTimeOut and QueryTimeOut parameters specified in the profile will override the LoginTimeOut and QueryTimeOut property values specified through the Replication object.

See Also

Reference

LoginTimeout Property (Replication)
QueryTimeout Property (Replication)
Replication Object Properties

Help and Information

Getting SQL Server Compact Edition Assistance