다음을 통해 공유

  • 아티클

CheckCatalog 메서드

데이터베이스 카탈로그의 무결성을 테스트합니다.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
Public Function CheckCatalog As StringCollection
‘사용 방법
Dim instance As Database
Dim returnValue As StringCollection

returnValue = instance.CheckCatalog()

public StringCollection CheckCatalog()

public:
StringCollection^ CheckCatalog()

member CheckCatalog : unit -> StringCollection 

public function CheckCatalog() : StringCollection

반환 값

유형: System.Collections.Specialized. . :: . .StringCollection
데이터베이스의 카탈로그 무결성에 대한 보고서를 포함하는 StringCollection 개체 값입니다.

주의

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

예

VB

'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)
}