Check database consistency

if exists( select * from sys.objects where name ='mgt_check_db')
 drop proc mgt_check_db
go

create proc mgt_check_db (
 @db_name sysname
)
as

DBCC CHECKDB(@db_name);

go