create table #t (Error int, Level int , State int, MessageText nvarchar(4000)
,RepairLevel int, Status int, DbId int, ObjectId int, IndexId int, PartitionId int,
AllocUnitId int, [File] int, Page int, Slot int, RefFile int,RefPage int
, RefSlot int, Allocation int
)
insert #t exec('DBCC CHECKDB(''NIR'') WITH TABLERESULTS')
select * from #t
临时表存储DBCC消息信息
最新推荐文章于 2022-09-09 09:59:49 发布