Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Database.CheckAllocationsDataOnly Method ()


Scans all pages of the referenced database and tests only the data to help ensure integrity.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Public Function CheckAllocationsDataOnly As StringCollection

Return Value

Type: System.Collections.Specialized.StringCollection

A StringCollection object value that contains a report about the allocations in the database.

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



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

$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)
Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft