Database.Owner 屬性

發行項
04/26/2013

Gets the database principal that is the owner of the database.

此 API 不符合 CLS 標準。

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

語法

'宣告
<SfcReferenceAttribute(GetType(Login), "Server[@Name = '{0}']/Login[@Name = '{1}']",  _
    )> _
<CLSCompliantAttribute(False)> _
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property Owner As String 
    Get
'用途
Dim instance As Database 
Dim value As String 

value = instance.Owner

[SfcReferenceAttribute(typeof(Login), "Server[@Name = '{0}']/Login[@Name = '{1}']", 
    )]
[CLSCompliantAttribute(false)]
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public string Owner { get; }

[SfcReferenceAttribute(typeof(Login), L"Server[@Name = '{0}']/Login[@Name = '{1}']", 
    )]
[CLSCompliantAttribute(false)]
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
virtual property String^ Owner {
    String^ get () sealed;
}

[<SfcReferenceAttribute(typeof(Login), "Server[@Name = '{0}']/Login[@Name = '{1}']", 
    )>]
[<CLSCompliantAttribute(false)>]
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
abstract Owner : string
[<SfcReferenceAttribute(typeof(Login), "Server[@Name = '{0}']/Login[@Name = '{1}']", 
    )>]
[<CLSCompliantAttribute(false)>]
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
override Owner : string

final function get Owner () : String

屬性值

型別：System.String
A String value that specifies the database principal that owns the database.

實作

IDatabaseOptions.Owner

備註

The database owner can be changed by using the SetOwner method.

範例

'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 information about the database.
Console.WriteLine("Name = " + db.Name.ToString)
Console.WriteLine("ID = " + db.ID.ToString)
Console.WriteLine("Owner = " + db.Owner.ToString)
Console.WriteLine("Parent = " + db.Parent.ToString)
Console.WriteLine("State = " + db.State.ToString)
Console.WriteLine("Status = " + db.Status.ToString)
Console.WriteLine("User Name = " + db.UserName.ToString)
Console.WriteLine("DBO Login = " + db.DboLogin.ToString)
Console.WriteLine("Version = " + db.Version.ToString)
Console.WriteLine("Service Broker = " + _
db.ServiceBroker.ToString)
Console.WriteLine("Replication Options = " + _
db.ReplicationOptions.ToString)
Console.WriteLine("Default File Group = " + _
db.DefaultFileGroup.ToString)
Console.WriteLine("Default FTS catalog = " + _
db.DefaultFullTextCatalog.ToString)
Console.WriteLine("Default Schema = " + _
db.DefaultSchema.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 "Name =" $db.Name
Write-Host "ID =" $db.ID
Write-Host "Owner =" $db.Ownder
Write-Host "Parent =" $db.Parent
Write-Host "State =" $db.State
Write-Host "Status =" $db.Status
Write-Host "User Name =" $db.UserName
Write-Host "DBO Login =" $db.DboLogin
Write-Host "Version =" $db.Version
Write-Host "Service Broker =" $db.ServiceBroker
Write-Host "Replication Options =" $db.ReplicationOptions
Write-Host "Default File Group =" $db.DefaultFileGroup
Write-Host "Default FTS catalog =" $db.DefaultFullTextCatalog
Write-Host "Default Schema =" $db.DefaultSchema