This topic has not yet been rated - Rate this topic

DatabaseActiveDirectory Class

SQL Server 2008

The DatabaseActiveDirectory object provides programmatic access to the Active Directory settings for a database.

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

Syntax

C++

JScript

public sealed class DatabaseActiveDirectory : SqlSmoObject

Remarks

The DatabaseActiveDirectory object allows you to:

Register a database in the Active Directory service.
Update the database information in Active Directory service.
Create an alias for the database that appears in the Active Directory service.
Create a contact, a description and an information URL for the database that appears in the Active Directory service.
Delete the database registration information from Active Directory service.

To get or set DatabaseActiveDirectory object properties, users must be a member of the db_owner fixed database role or the sysadmin fixed server role.

Thread Safety

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

Inheritance Hierarchy

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

Thread Safety

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

Reference

DatabaseActiveDirectory Members

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Calling Methods

sp_ActiveDirectory_Obj (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD