發行項
04/02/2012

CheckAllocations 方法

掃描受參考資料庫的所有頁面並測試頁面，以確保完整性。

命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Function CheckAllocations ( _
    repairType As RepairType _
) As StringCollection
'用途
Dim instance As Database
Dim repairType As RepairType
Dim returnValue As StringCollection

returnValue = instance.CheckAllocations(repairType)

public StringCollection CheckAllocations(
    RepairType repairType
)

public:
StringCollection^ CheckAllocations(
    RepairType repairType
)

member CheckAllocations : 
        repairType:RepairType -> StringCollection

public function CheckAllocations(
    repairType : RepairType
) : StringCollection

參數

repairType
型別：Microsoft.SqlServer.Management.Smo. . :: . .RepairType
指定修復選項的 RepairType 物件值。

傳回值

型別：System.Collections.Specialized. . :: . .StringCollection
包含資料庫配置之相關報表的 StringCollection 物件值。

備註

This method is equivalent to the DBCC CHECKALLLOC Transact-SQL statement.

範例

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
'Note, to use the StringCollection type the System.Collections.Specialized system namespace must be included in the imports statements.
Dim sc As StringCollection
'Run the CheckTables method and display the results from the returned StringCollection variable.
sc = db.CheckTables(RepairType.None)
Dim c As Integer
For c = 0 To sc.Count - 1
    Console.WriteLine(sc.Item(c))
Next

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")

$sc = new-object System.Collections.Specialized.StringCollection
$sc = $db.CheckTables([Microsoft.SqlServer.Management.Smo.RepairType]'None')
$c = 0
For ($c=0; $c -le $sc.Count - 1; $c++)
{
   Write-Host $sc.Item($c)
}