Database.AutoUpdateStatisticsEnabled Database.AutoUpdateStatisticsEnabled Database.AutoUpdateStatisticsEnabled Property

Definition

Gets or sets a value that specifies whether statistics are automatically updated for the database.

public:
 property bool AutoUpdateStatisticsEnabled { bool get(); void set(bool value); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.SqlAzureDatabase | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Deploy)]
public bool AutoUpdateStatisticsEnabled { get; set; }
Public Property AutoUpdateStatisticsEnabled As Boolean
Property Value

A Boolean value that specifies the whether statistics are automatically updated for the database.

If True, statistics are automatically updated for the database. Otherwise, False (default).

Implements

Examples

VB

'Connect to the local, default instance of SQL Server.  
Dim srv As Server  
srv = New Server  

'Reference the AdventureWorks2012 database.  
Dim db As Database  
db = srv.Databases("AdventureWorks2012")  

'Display the current options for statistics.  
Console.WriteLine("Automatically create statistics = " + _  
db.AutoCreateStatisticsEnabled.ToString)  
Console.WriteLine("Automatically update statistics = " + _  
db.AutoUpdateStatisticsEnabled.ToString)  

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$db = New-Object Microsoft.SqlServer.Management.Smo.Database  
$db = $srv.Databases.Item("AdventureWorks2012")  
Write-Host "Automatically create statistics =" $db.AutoCreateStatisticsEnabled  
Write-Host "Automatically update statistics =" $db.AutoUpdateStatisticsEnabled  

Remarks

The AutoUpdateStatisticsEnabled property is equivalent to setting the AUTO_UPDATE_STATISTICS ON option in the ALTER DATABASE Transact-SQL statement.

Applies to