Condividi tramite

  • Articolo

Proprietà Owner

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

Spazio dei nomi:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
<SfcPropertyAttribute> _
Public ReadOnly Property Owner As String
    Get
'Utilizzo
Dim instance As Database
Dim value As String

value = instance.Owner

[SfcPropertyAttribute]
public string Owner { get; }

[SfcPropertyAttribute]
public:
property String^ Owner {
    String^ get ();
}

[<SfcPropertyAttribute>]
member Owner : string

function get Owner () : String

Valore proprietà

Tipo: System. . :: . .String
A String value that specifies the database principal that owns the database.

Osservazioni

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

Esempi

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

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

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