How can we help you today? How can we help you today?

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
torsten.strauss
0

Comments

5 comments

Sort by
  • way0utwest
    Confirmed this as an issue with Prompt 8.2.2.x
    way0utwest
    0
  • 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.
    helehin
    0
  • 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...
    torsten.strauss
    0
  • helehin
    For me it is not fixed in 8.2.5.2924
    helehin
    0
  • 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.
    torsten.strauss
    0

Add comment

Please sign in to leave a comment.