Partilhar via

Application.DatabaseName Property

  • Artigo

Gets or sets the name of the application database.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

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

Property Value

A String, between 1 and 128 characters in length, specifying the name of the application database.

Remarks

Specify this property only if you are creating a new application. Existing applications already have a database, and the database name cannot be changed after creating the application. If you attempt to change a database name, Notification Services Management Objects (NMO) throws an exception.

If you do not specify a database name when creating a Notification Services application, the default database name is a concatenation of the instance name and the application name.

If you specify a DatabaseName, you should provide a SchemaName for all application database objects. The default schema is dbo.

Database names can be up to 128 characters in length. For more information about database names, see the database_name parameter in CREATE DATABASE (Transact-SQL).

Important

The specified database must be set to 90 compatibility mode.

Example

The following example shows how to set the name of the application database and the schema for application objects:

myApplication.DatabaseName = "MyInstMyApp";
myApplication.SchemaName = "MyAppSchema";

myApplication.DatabaseName = "MyInstMyApp"
myApplication.SchemaName = "MyAppSchema"

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.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

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

Other Resources

sp_dbcmptlevel (Transact-SQL)
Defining the Application Database
DatabaseName Element (ADF)