通过

Server.IsDetachedPrimaryFile Method

  • 项目

Verifies whether the specified file is a primary (.mdf) database file.

命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public Function IsDetachedPrimaryFile ( _
    mdfName As String _
) As Boolean

public bool IsDetachedPrimaryFile (
    string mdfName
)

public:
bool IsDetachedPrimaryFile (
    String^ mdfName
)

public boolean IsDetachedPrimaryFile (
    String mdfName
)

public function IsDetachedPrimaryFile (
    mdfName : String
) : boolean

参数

  • mdfName
    A String value that specifies the name of the data file.

返回值

A Boolean value that specifies whether the data file is a primary database file. If True, the data file is a primary database file. If False, the data file is not a primary database file.

备注

已更新的文本：

仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。

示例

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
Dim owner As String
Dim logstr as String
Dim datastr as String
owner = srv.Databases("AdventureWorks").Owner

'Detach the AdventureWorks database.
srv.DetachDatabase("AdventureWorks", False, False)

'Display information about the detached database.
Dim d As DataTable
Datastr = "C:\Program Files\Microsoft SQL Server"
Datastr = datastr + "\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf"
Logstr = "C:\Program Files\Microsoft SQL Server"
Logstr = datastr + "\MSSQL.1\MSSQL\Data\AdventureWorks_Log.ldf"
d = srv.DetachedDatabaseInfo(datastr)
Dim r As DataRow
Dim c As DataColumn
For Each r In d.Rows
    Console.WriteLine("==========================")
    For Each c In r.Table.Columns
        Console.WriteLine(c.ColumnName + " = " + r(c).ToString)
    Next
Next

'Check whether the file is a detached primary file.
Console.WriteLine(srv.IsDetachedPrimaryFile(datastr))

'Attach the database
Dim sc As StringCollection
sc = New StringCollection
sc.Add(datastr)
sc.Add(logstr)
srv.AttachDatabase("AdventureWorks", sc, owner, AttachOptions.None)

线程安全

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 的硬件和软件要求。

目标平台

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

请参阅

参考

Server Class
Server Members
Microsoft.SqlServer.Management.Smo Namespace

其他资源

How to: Use an SMO Method with a Parameter in Visual Basic .NET
Calling Methods
管理服务器