Home
  •  

Check Catalog (DBCC)

Microsoft.SQLServer.2014.Database.DBCC.CheckCatalog (Task)

Checks for catalog consistency within the specified database. The database must be online.

Element properties:

TargetMicrosoft.SQLServer.2014.Database
AccessibilityInternal
CategoryMaintenance
EnabledTrue
RemotableFalse
Timeout300

Member Modules:

ID Module Type TypeId RunAs 
PA ProbeAction System.CommandExecuterProbe Microsoft.SQLServer.2014.SecureReference.Task

Source Code:

<Task ID="Microsoft.SQLServer.2014.Database.DBCC.CheckCatalog" Target="SQL2014Core!Microsoft.SQLServer.2014.Database" Accessibility="Internal" Enabled="true">

  <Category>Maintenance</Category>

  <ProbeAction ID="PA" TypeID="System!System.CommandExecuterProbe" RunAs="SQL2014Core!Microsoft.SQLServer.2014.SecureReference.Task">

    <ApplicationName>$Target/Host/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/ToolsPath$\Binn\OSQL.EXE</ApplicationName>

    <WorkingDirectory>$Target/Host/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/ToolsPath$\Binn</WorkingDirectory>

    <CommandLine>-S "$Target/Host/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/ConnectionString$,$Target/Host/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.DBEngine"]/TcpPort$" -E -Q "DBCC CHECKCATALOG('$Target/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.Database"]/DatabaseName$')"</CommandLine>

    <TimeoutSeconds>300</TimeoutSeconds>

    <RequireOutput>true</RequireOutput>

  </ProbeAction>

</Task>