Instance.DatabaseName Property

项目
12/15/2008

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.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台