SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Database Engine
Technical Reference
SQL-DMO Reference
Methods (SQL-DMO)
E (SQL-DMO Methods)
EnableAgentOffload Method
EnableFullTextCatalogs Method
EnableMergeSubscription Method
EnableTransSubscription Method
EnumAccountInfo Method
EnumAgentErrorRecords Method
EnumAgentParameters Method
EnumAgentProfiles Method
EnumAlerts Method
EnumAllSubscriptions Method
EnumAllSubsetFilters Method
EnumAlternatePublishers Method
EnumAvailableMedia Method
EnumCandidateKeys Method
EnumCollations Method
EnumColumns Method
EnumConflictTables Method
EnumCustomResolvers Method
EnumDatabaseMappings Method
EnumDatabaseRoleMember Method
EnumDataSourceNames Method
EnumDependencies Method
EnumDirectories Method
EnumDistributionAgentSessionDetails Method
EnumDistributionAgentSessionDetails2 Method
EnumDistributionAgentSessions Method
EnumDistributionAgentSessions2 Method
EnumDistributionAgentViews Method
EnumDistributionAgentViews2 Method
EnumErrorLogs Method
EnumFileGroups Method
EnumFiles Method (Database)
EnumFiles Method (FileGroup)
EnumFixedDatabaseRolePermission Method
EnumFullTextLanguages Method
EnumGeneratedSubsetFilters Method
EnumHistory Method
EnumIdentityRangeInfo Method
EnumInitialAccesses Method
EnumJobHistory Method
EnumJobInfo Method
EnumJobNotifications Method
EnumJobs Method
EnumLastStatisticsUpdates Method
EnumLocks Method
EnumLoginMappings Method
EnumLogReaderAgentSessionDetails Method
EnumLogReaderAgentSessionDetails2 Method
EnumLogReaderAgentSessions Method
EnumLogReaderAgentSessions2 Method
EnumLogReaderAgentView Method
EnumLogReaderAgentViews Method
EnumMatchingSPs Method
EnumMergeAgentSessionDetails Method
EnumMergeAgentSessionDetails2 Method
EnumMergeAgentSessions Method
EnumMergeAgentSessions2 Method
EnumMergeAgentViews Method
EnumMergeAgentViews2 Method
EnumMiscellaneousAgentViews Method
EnumNotifications Method
EnumNTDomainGroups Method
EnumNTGroups Method
EnumObjects Method
EnumOutputs Method
EnumParameters Method
EnumProcesses Method
EnumPublicationAccesses Method
EnumPublicationArticles Method
EnumPublicationReferences Method
EnumPublications Method
EnumPublications2 Method
EnumQueueReaderAgentSessionDetails Method
EnumQueueReaderAgentSessions Method
EnumQueueReaderAgentView Method
EnumQueueReaderAgentViews Method
EnumReferencedKeys Method
EnumReferencedTables Method
EnumReferencingKeys Method
EnumReferencingTables Method
EnumServerAttributes Method
EnumServerRoleMember Method
EnumServerRolePermission Method
EnumSnapshotAgentSessionDetails Method
EnumSnapshotAgentSessionDetails2 Method
EnumSnapshotAgentSessions Method
EnumSnapshotAgentSessions2 Method
EnumSnapshotAgentView Method
EnumSnapshotAgentViews Method
EnumStatistics Method
EnumSubscriptions Method
EnumSubscriptionViews Method
EnumSubscriptionViews2 Method
EnumSubSystems Method
EnumTables Method
EnumTargetServers Method
EnumThirdPartyPublications Method
EnumThirdPartyPublications2 Method
EnumThirdPartyVendorNames Method
EnumUsers Method
EnumVersionInfo Method
ExecuteImmediate Method (Database, SQLServer)
ExecuteImmediate Method (LinkedServer, RemoteServer)
ExecuteWithResults Method
ExecuteWithResultsAndMessages Method
ExecuteWithResultsAndMessages2 Method
ExportData Method
Expand Minimize
This topic has not yet been rated - Rate this topic

EnumLastStatisticsUpdates Method

SQL Server 2008

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The EnumLastStatisticsUpdates method returns a QueryResults object that enumerates the query optimizing statistics maintained on a table.

Copy 
object.EnumLastStatisticsUpdates( [ IndexName ] )as QueryResults
object

Expression that evaluates to an object in the Applies To list.

IndexName

Optional. String that names an existing index and that restricts output to the index named.

Copy 
HRESULT EnumLastStatisticsUpdates(
LPSQLDMOQUERYRESULTS* ppResults,
SQLDMO_LPCSTR IndexName = NULL);

A QueryResults object that contains one result set defined by these columns.

Column

Data type

Description

last update

smalldatetime

Date and time of most recent update. When NULL, the distribution statistics have not been updated after object creation.

name

nvarchar(129)

Index name or statistics definition name.

Data distribution statistics are maintained for indexes defined on a table and as directed by the user. By default, the EnumLastStatisticsUpdates method returns a result set that contains rows referencing both indexes and system and user-defined data distribution statistics.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.