New training course: Customizing SQL Prompt. Watch now.

DBCC WITH TABLERESULTS;

Hi Redgate Team,

the following command will become invalid by formatting the code by adding AS.

DBCC PAGE(TransactionLog,2,0,3) WITH TABLERESULTS;
GO

--after formatting
DBCC PAGE(TransactionLog,2,0,3) WITH AS TABLERESULTS;
GO

This seems to be true for all DBCC commands with the option WITH TABLERESULTS.

This will cause SQL prompt and the code to fail.

Would be good to see a fix in the next release - thanks!

Torsten

Comments

Sign In or Register to comment.