Partager via


SchemaName Element (ADF)

Specifies the database schema for all application database objects.

Syntaxe

<Database>
    <DatabaseName>

Element Characteristics

Characteristic Description

Data type

string, between 1 and 128 characters in length.

Default value

dbo.

Occurrence

Optional once per Database element. Required if using the DatabaseName element.

Updates

Cannot be added, deleted, or modified when updating the instance.

Element Relationships

Relationship Elements

Parent element

Database Element (ADF)

Child elements

None.

Notes

In SQL Server 2005 Notification Services, you can specify the name of the application database. This database can be a new or existing database. Because the application database objects must be isolated from other instance or application database objects, you should specify a unique schema name if you specify a database name. For more information about database schemas, see Séparation du schéma et de l'utilisateur.

All application database objects are created in the specified schema.

If you do not specify the database name and schema name, Notification Services creates a new database with the name instanceName + applicationName, and creates all application database objects in the dbo schema. The instance name and application name are specified in the instance configuration file (ICF).

For more information about database schemas, see Séparation du schéma et de l'utilisateur.

Exemple

The following example shows how define a Stock schema for all application database objects.

<SchemaName>Stock</SchemaName>

Voir aussi

Référence

Application Definition File Reference

Concepts

Instance Configuration File Reference

Autres ressources

Définition de la base de données d'application
Séparation du schéma et de l'utilisateur
CREATE SCHEMA (Transact-SQL)
Mise à jour des instances et des applications

Aide et Informations

Assistance sur SQL Server 2005