共用方式為


Database.ActiveDirectory 屬性

注意:此 API 已經過時。

Gets the information about the Active Directory settings for the database.

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcObjectAttribute(SfcObjectRelationship.Object, SfcObjectCardinality.One)> _
<ObsoleteAttribute> _
Public ReadOnly Property ActiveDirectory As DatabaseActiveDirectory 
    Get
'用途
Dim instance As Database 
Dim value As DatabaseActiveDirectory 

value = instance.ActiveDirectory
[SfcObjectAttribute(SfcObjectRelationship.Object, SfcObjectCardinality.One)]
[ObsoleteAttribute]
public DatabaseActiveDirectory ActiveDirectory { get; }
[SfcObjectAttribute(SfcObjectRelationship::Object, SfcObjectCardinality::One)]
[ObsoleteAttribute]
public:
property DatabaseActiveDirectory^ ActiveDirectory {
    DatabaseActiveDirectory^ get ();
}
[<SfcObjectAttribute(SfcObjectRelationship.Object, SfcObjectCardinality.One)>]
[<ObsoleteAttribute>]
member ActiveDirectory : DatabaseActiveDirectory
function get ActiveDirectory () : DatabaseActiveDirectory

屬性值

型別:Microsoft.SqlServer.Management.Smo.DatabaseActiveDirectory
A DatabaseActiveDirectory object that specifies the Active Directory settings for the database.

備註

The ActiveDirectory property points to a DatabaseActiveDirectory object, which can be used to register the referenced database Active Directory.

When you call the Register method to add a database to Active Directory, users can use Active Directory to find this database. This is useful in large organizations with many databases.

範例

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")

'Register the AdventureWorks2012 database in the Active Directory 
'directory service.
db.ActiveDirectory.Register()

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")
$db.ActiveDirectory.Register()

請參閱

參考

Database 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

使用資料庫物件

Active Directory Stored Procedures (Transact-SQL)

建立、改變和移除資料庫

CREATE DATABASE (Transact-SQL)