Intellisense stops referencing UD variables in long code.

Haakonp

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

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.)

Anu D

Thanks for your post Haakon.

I have emailed you the workaround for this issue.

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

Anu D

Did that helped Haakon?