LastDistributionSummaryTime Property
The LastDistributionSummaryTime property returns the date and time when the last synchronization summary text was logged by the Distribution Agent.
Applies To
| TransPullSubscription2 Object |
Syntax
object.LastDistributionSummaryTime
Parts
object
Expression that evaluates to an object in the Applies To list
Data Type
String
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetLastDistributionSummaryTime(SQLDMO_LPBSTR pRetVal);
Note SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference by using SysFreeString.
Remarks
LastDistributionSummaryTime 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 LastDistributionSummary on an instance of SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000" are returned.