SQL Server Performance Forum – Threads Archive
which DBCC command support TABLERESULTSCan we use TABLERESULTS with all the DBCC Command? If not why is it so. Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–
TABLERESULTS are applicable NOT to all the DBCC command.
it’s applicable to dbcc showcontig(). Tom Pullen
DBA, Oxfam GB
You can use ‘WITH TABLERESULTS’ option for most of these DBCC statements to get an output that can be piped to a temporary table for analysis. This has been implemented for most of the DBCC statements in SQL2000. Why not for few other DBCC statements, means you need to check into inside SQL Server book for any information. HTH Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.