Instance.DatabaseName Property

Artículo
12/15/2008

Gets or sets the name of the instance database.

Espacio de nombres: Microsoft.SqlServer.Management.Nmo
Ensamblado: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Sintaxis

'Declaración
Public Property DatabaseName As String

public string DatabaseName { get; set; }

public:
property String^ DatabaseName {
    String^ get ();
    void set (String^ value);
}

/** @property */
public String get_DatabaseName ()

/** @property */
public void set_DatabaseName (String value)

public function get DatabaseName () : String

public function set DatabaseName (value : String)

Valor de propiedad

A String, between 1 and 128 characters in length, that specifies the name of the instance database.

Notas

In SQL Server 2005 Notification Services, you can specify the name of the instance database. This database can be a new or existing database. If the database already exists, Notification Services creates instance objects in the specified SchemaName of the existing database. If the database does not exist, Notification Services creates a new database with the specified name and creates instance objects in the specified SchemaName.

Importante:
The specified database must be using 90 compatibility mode.

If you do not specify the database name, Notification Services creates a new database with the name instanceNameNSMain, and creates all instance objects in the dbo schema.

When you delete an instance of Notification Services, Notification Services deletes the instance database only if Notification Services created the database. Otherwise, Notification Services only deletes the instance objects and the related application objects from the database.

For more information about database names, see the database_name parameter in CREATE DATABASE (Transact-SQL).

Ejemplo

The following examples show how to specify a name for the instance database and a schema for instance objects:

myInstance.DatabaseName = "MyInstNSMain";
myInstance.SchemaName = "MyInstSchema";

myInstance.DatabaseName = "MyInstNSMain"
myInstance.SchemaName = "MyInstSchema"

Seguridad para subprocesos

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Plataformas

Plataformas de desarrollo

Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.

Plataformas de destino