Instance.DatabaseName Property

Gets or sets the name of the instance database.

Пространство имен: Microsoft.SqlServer.Management.Nmo
Сборка: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Синтаксис

'Декларация
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)

Значение свойства

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

Замечания

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.

Важно!
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).

Пример

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"

Синхронизация потоков

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.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

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

Другие ресурсы

Настройка экземпляров служб Notification Services
DatabaseName Element (ICF)