SQL-DMO
LastMergedTime Property
The LastMergedTime property returns the last time a merge replication operation occurred between the Publisher and the Subscriber.
Applies To
| MergePullSubscription2 Object |
Syntax
object.LastMergedTime
Parts
object
Expression that evaluates to an object in the Applies To list
Data Type
String
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetLastMergedTime(SQLDMO_LPBSTR pRetVal);
Remarks
Use the LastMergedTime property to determine if replicated data at a pull Subscriber is up-to-date.
LastMergedTime returns the data formatted as YYYYMMDD hh:mm:ss.fff.
| Date part | Description |
|---|---|
| YYYY | Represents the year in four digits. |
| MM | Represents the month in two digits (zero padded). |
| DD | Represents the day of the month in two digits (zero padded). |
| hh | Represents the hour using two digits, a twenty-four hour clock and zero padding. |
| mm | Represents the minute in two digits (zero padded). |
| ss | Represents the second in two digits (zero padded). |
| fff | Represents the fractional part of the second in three digits. |
For example, the value 19990911 18:12:00.000 is interpreted as 6:12 P.M., September 11, 1999.
Note If an application calls LastMergedTime on an instance of SQL Server version 7.0, an empty string is returned.