LastDistributionSummaryTime Property
未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能，並規劃修改目前使用這項功能的應用程式。
The LastDistributionSummaryTime property returns the date and time when the last synchronization summary text was logged by Distribution Agent.
語法
object
.LastDistributionSummaryTime
Parts
- object
An 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);
[!附註]
SQL Distributed Management Objects (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.
備註
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 20040512 18:12:00.000 is interpreted as 6:12 P.M., May 12, 2004.
The LastDistributionSummaryTime property applies only to push subscriptions. The property will return an empty string for pull or anonymous subscriptions.
[!附註]
If an application calls LastDistributionSummaryTimeon 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 or later" are returned.