This topic has not yet been rated - Rate this topic

DatabaseOptions Class

SQL Server 2005

The DatabaseOptions object represents a Microsoft SQL Server database options.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

C++

public sealed class DatabaseOptions : SqlSmoObject, IAlterable

public final class DatabaseOptions extends SqlSmoObject implements IAlterable

JScript

public final class DatabaseOptions extends SqlSmoObject implements IAlterable

Remarks

Updated text:

Configurable database options, such as ANSI settings, cursor settings, arithmetic behavior, recovery model, and the read-only status, are contained in the DatabaseOptions object. The DatabaseOptions object is a child of the Database object.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Inheritance Hierarchy

System.Object
   Microsoft.SqlServer.Management.Smo.SmoObjectBase
     Microsoft.SqlServer.Management.Smo.SqlSmoObject
      Microsoft.SqlServer.Management.Smo.DatabaseOptions

Example

How to: Get and Set a Property in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Release	History
	New content: Added text stating that the AutoShrink property is equivalent to setting the db_option autoshrink option in Transact-SQL.
	New content: Added the IsParameterizationForced property.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

DatabaseOptions Class

Development Platforms

Target Platforms

Reference

Other Resources

Community Additions