Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Database.CheckCatalog Method ()


Tests the integrity of the database catalog.

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

member CheckCatalog : unit -> StringCollection

Return Value

Type: System.Collections.Specialized.StringCollection

A StringCollection object value that contains a report about the integrity of the catalog in the database.

This method is equivalent to the DBCC CATALOG 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