DatabaseName Element (ICF)
Specifies the name of the instance database.
Syntax
<Database>
<DatabaseName>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type |
string, between 1 and 128 characters in length. |
Default value |
InstanceName element value + NSMain. |
Occurrence |
Optional once per Database element. |
Updates |
Cannot be added, deleted, or modified when updating the application. |
Element Relationships
| Relationship | Elements |
|---|---|
Parent element |
|
Child elements |
None. |
Remarks
In Microsoft 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 schema 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 schema.
Important
The specified database must be using 90 compatibility mode.
If you specify a database name, you should specify a unique schema using the SchemaName element. All instance objects are created in that schema.
If you do not specify the database name and schema name, Notification Services creates a new database with the name instanceNameNSMain, where instanceName is the value of the InstanceName element, and creates all instance objects in the dbo schema.
When you delete an instance of Notification Services, Notification Services will delete 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).
Example
The following example shows how to use the StockInstance database as the instance database. If the StockInstance database exists, Notification Services uses the existing database. If the StockInstance database does not exist, Notification Services creates it.
<DatabaseName>StockInstance</DatabaseName>
See Also
Reference
Application Definition File Reference
Concepts
Instance Configuration File Reference
Other Resources
Defining the Instance Database
CREATE DATABASE (Transact-SQL)