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