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

Intellisense stops referencing UD variables in long code.

It appears that SQL Prompt intellisense works as designed until a certain line number (around 500 or so).

Our business loves mega-reports and I end up with these very large SPs. Towards the end of these SPs, I can't seem to reference any temp tables, variable tables, or variables.

Does anyone else have this issue, or a solution that doesn't involve "make your SPs shorter?

Thanks!

-Haakon
Haakonp
0

Comments

4 comments

Sort by
  • MikeyC
    Yes, I have the same problem. Red Gate has said that this is a design decision to make SQL Prompt faster. If you contact support they can give you some instructions for modifying the XML config files to have it look at more of the batch, but it makes SSMS really slow. (This started in SQL Prompt 4, in SQL Prompt 3 they had the option to look at the entire batch, and it wasn't this slow.)
    MikeyC
    0
  • Anu D
    Thanks for your post Haakon.

    I have emailed you the workaround for this issue.
    Anu D
    0
  • Haakonp
    Excellent guys, appreciate the fast and accurate responses!

    I'll fiddle with the <ParserLookBackDistance> and ><ParserLookAheadDistance> properties of the config and see if I can get a bit further down without blowing up SSMS.

    Thanks again!

    -Haakon
    Haakonp
    0
  • Anu D
    Did that helped Haakon?
    Anu D
    0

Add comment

Please sign in to leave a comment.