DatabaseIntegrityCheck - Allocation and Catalog Checks Only

DatabaseIntegrityCheck - Allocation and Catalog Checks Only.sql

DECLARE @MaxEndTime datetime = DATEADD(HOUR, 2, GETDATE())
DECLARE @TimeLimitSeconds int;

SET @TimeLimitSeconds = DATEDIFF(second, GETDATE(), @MaxEndTime)

EXEC dbo.DatabaseIntegrityCheck
	@Databases = 'ALL_DATABASES',
	@DatabaseOrder = 'DATABASE_LAST_GOOD_CHECK_ASC',
	@CheckCommands = 'CHECKALLOC,CHECKCATALOG',
	--@PhysicalOnly = 'Y',
	@TimeLimit = @TimeLimitSeconds,
	@LogToTable= 'Y',
	@Execute = 'Y'