This recipe shows you some of the DBCC commands that can be run using PowerShell.
Follow these steps to run DBCC commands:
Open PowerShell ISE as administrator.
Import the SQLPS module and create a new SMO Server object:
#import SQL Server module Import-Module SQLPS -DisableNameChecking #replace this with your instance name $instanceName = "localhost" $server = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName
Some DBCC commands are built into SMO, so you can just call the methods:
$databasename = "AdventureWorks2014" $database = $server.Databases[$databasename] #RepairType Values: AllowDataLost, Fast, None, Rebuild $database.CheckTables([Microsoft.SqlServer.Management.Smo.RepairType]::None)