Server.DetachedDatabaseInfo(String) Server.DetachedDatabaseInfo(String) Server.DetachedDatabaseInfo(String) Method

정의

분리된 데이터베이스 파일에 대한 정보를 반환합니다. Returns information about a detached database file.

public:
 System::Data::DataTable ^ DetachedDatabaseInfo(System::String ^ mdfName);
public System.Data.DataTable DetachedDatabaseInfo (string mdfName);
Public Function DetachedDatabaseInfo (mdfName As String) As DataTable
매개 변수
mdfName
String String String

분리된 데이터베이스 파일을 지정하는 String 값입니다. A String value that specifies the detached database file.

반환

A DataTable 분리 된 데이터베이스 파일에 대 한 정보 목록을 포함 하는 시스템 개체 값입니다. A DataTable system object value that contains a list of information about a detached database file. 반환 된 다른 열을 설명 하는 테이블 DataTable합니다. The table describes the different columns of the returned DataTable.

Column Data type Description
DatabaseName String The name of the database.
DatabaseVersion String The version of the database.
Collation String The number of the collation that is used with the database.
Column Data type Description
DatabaseName String The name of the database.
DatabaseVersion String The version of the database.
Collation String The number of the collation that is used with the database.

예제

Visual BasicVisual Basic

'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("AdventureWorks2012").Owner  

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

'Display information about the detached database.  
Dim d As DataTable  
Datastr = "C:\Program Files\Microsoft SQL Server"  
Datastr = datastr + "\MSSQL10_50\MSSQL\Data\AdventureWorks2012_Data.mdf"  
Logstr = "C:\Program Files\Microsoft SQL Server"  
Logstr = datastr + "\MSSQL10_50\MSSQL\Data\AdventureWorks2012_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("AdventureWorks2012", sc, owner, AttachOptions.None)  

PowerShellPowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$db = New-Object Microsoft.SqlServer.Management.Smo.Database  
$db = $srv.Databases.Item("AdventureWorks2012")  
$owner = $db.Owner  
$srv.DetachDatabase("AdventureWorks2012", $FALSE, $FALSE)  
$datastr = "C:\Program Files\Microsoft SQL Server"  
$datastr = $datastr + "\MSSQL10_50\MSSQL\Data\AdventureWorks2012_Data.mdf"  
$logstr = "C:\Program Files\Microsoft SQL Server"  
$logstr = $logstr + "\MSSQL10_50\MSSQL\Data\AdventureWorks2012_Log.ldf"  
$d = $srv.DetachedDatabaseInfo($datastr)  
foreach ($r in $d.Rows)  
{  
   Write-Host "=========================="  
   Foreach ($c in $d.Columns)  
   {  
      Write-Host $c.ColumnName "=" $r[$c].ToString()  
   }  
}  
Write-Host $srv.IsDetachedPrimaryFile($datastr)  
$sc = new-object Systems.Collections.Specialized.StringCollection  
$sc.Add($datastr)  
$sc.Add($logstr)  
$srv.AttachDatabase("AdventureWorks2012", $sc, $owner, [Microsoft.SqlServer.Management.Smo.AttachOptions]::None)  

적용 대상

추가 정보