which DBCC command support TABLERESULTS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

which DBCC command support TABLERESULTS

Can 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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>