Compartir a través de

  • Artículo

Owner Propiedad

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

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
<SfcPropertyAttribute> _
Public ReadOnly Property Owner As String
    Get
'Uso
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

Valor de la propiedad

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

Notas

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

Ejemplos

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