What are the challenges you face when working across database platforms? Take the survey
Options

Intellisense stops referencing UD variables in long code.

HaakonpHaakonp Posts: 3
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

Comments

  • Options
    MikeyCMikeyC Posts: 249 Bronze 3
    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.)
  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for your post Haakon.

    I have emailed you the workaround for this issue.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    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
  • Options
    Anu DAnu D Posts: 876 Silver 3
    Did that helped Haakon?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.