Instance.DatabaseName Property

Gets or sets the name of the instance database.

Espace de noms: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntaxe

'Déclaration
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)

Valeur de propriété

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

Notes

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.

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

Exemple

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"

Sécurité des threads

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.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

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

Autres ressources

Configuration des instances de Notification Services
DatabaseName Element (ICF)