Instance.DatabaseName Property

Gets or sets the name of the instance database.

Spazio dei nomi: Microsoft.SqlServer.Management.Nmo
Assembly : Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Sintassi

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

Valore proprietà

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

Osservazioni

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

Esempio

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"

Thread Safety

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.

Piattaforme

Piattaforme di sviluppo

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Piattaforme di destinazione

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Vedere anche

Riferimento

Instance Class
Instance Members
Microsoft.SqlServer.Management.Nmo Namespace

Altre risorse

Configurazione delle istanze di Notification Services
DatabaseName Element (ICF)