Login.DefaultDatabase Propiedad

Artículo
04/26/2013

Gets or sets the default database that the login account is assigned to after logging on to the instance of SQL Server.

Esta API no es compatible con CLS.

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

Sintaxis

'Declaración
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase,  _
    "master")> _
<SfcReferenceAttribute(GetType(Database), "Server[@Name = '{0}']/Database[@Name = '{1}']",  _
    )> _
<CLSCompliantAttribute(False)> _
Public Property DefaultDatabase As String 
    Get 
    Set
'Uso
Dim instance As Login 
Dim value As String 

value = instance.DefaultDatabase

instance.DefaultDatabase = value

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

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

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

final function get DefaultDatabase () : String 
final function set DefaultDatabase (value : String)

Valor de la propiedad

Tipo: System.String
A String value that specifies the default database to which the login account is assigned after logging on to the instance of SQL Server.

Implementa

ILoginOptions.DefaultDatabase

Comentarios

Logins are assigned to a database by default after logging on to the instance of SQL Server that is equivalent to the USE DatabaseName Transact-SQL statement.