DBCC WITH TABLERESULTS;

torsten.strauss

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

way0utwest

Confirmed this as an issue with Prompt 8.2.2.x

helehin

I have the same issue with no_infomsgs.

dbcc shrinkfile('x' , 0) with no_infomsgs;

becomes

dbcc shrinkfile('x' , 0) with as no_infomsgs;

after formatting.

torsten.strauss

Is this fixed in the new release?
At least for me it is working now but there is a space missing before WITH...

helehin

For me it is not fixed in 8.2.5.2924

torsten.strauss

You are right helehin!
It worked for the version before but not for 8.2.5.2924.
So it is still a bug.