Wednesday, March 21, 2012

dbcc output to table?

Hi,
is it possible to take dbcc output to a table? , if yes, please let me know how.
Thanks in Advance.
Ram.Youo will have to play with the table column definitions, but you can do this:

insert into table1
exec ('dbcc sqlperf(logspace)')

some DBCC commands even have a table format option (lookup DBCC showcontig) Hope this helps.|||thanks ! worked fine.

No comments:

Post a Comment