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

Two Issues

I have found two issues with SQL Refactor at this point:

1. It appears that the Layout SQL function is replacing some <CR><LF> (ACII 10 + ACII 13) characters with just <LF> (ASCII 10). I have not been able to determine the pattern yet. This is really doing odd things when doing an sp_helptext on a proc.

2. There seems to be some sort of oddities with the SQL Layout function. After laying out the proc and compiling it, sp_helptext shows that there are breaks in odd locations. I have seen it in the middle of a table name or in the middle of keywords. If I take the text of the proc and put it into TextPad and use the Convert to DOS function and then recompile the proc, the issue goes away.

Thanks,
Matt
mshepker
0

Comments

1 comment

Sort by
  • Andras B
    mshepker wrote:
    I have found two issues with SQL Refactor at this point:

    1. It appears that the Layout SQL function is replacing some <CR><LF> (ACII 10 + ACII 13) characters with just <LF> (ASCII 10). I have not been able to determine the pattern yet. This is really doing odd things when doing an sp_helptext on a proc.

    2. There seems to be some sort of oddities with the SQL Layout function. After laying out the proc and compiling it, sp_helptext shows that there are breaks in odd locations. I have seen it in the middle of a table name or in the middle of keywords. If I take the text of the proc and put it into TextPad and use the Convert to DOS function and then recompile the proc, the issue goes away.

    Thanks,
    Matt

    Hi Matt,

    many thanks for reporting this. We are looking at this problem, but it is affecting Management Studio. We will try to find a workaround for the final release.

    Regards,
    Andras
    Andras B
    0

Add comment

Please sign in to leave a comment.