Activity overview
Latest activity by RichBev61
Ed, Jack... thanks for the replies.
Unfortunately, I've been pulled to other non-db related tasks lately and haven't had time to explore more, but here are some facts/observations based on your replies:
* These anomalies seem to occur mainly in a few existing functions and procedures not when actively typing.
* the existing code is in production with no syntax or other uncompilable errors.
* I too, noticed that if I retyped or even copy-n-pasted the line that fails to trigger hints to the line above or below, it will then trigger the hints.
* I thought that maybe some unprintable ascii characters existing in the old code might be the culprit, but after copy-n-pasting into notepad ++ and showing all characters, nothing seemed abnormal.
* Finally, I tried re-formatting with SQLpromt's layout feature, as suggested and oddly enough, many of the objects that failed to trigger or triggered inconsistantly, now trigger consistantly. BUT... a few items in the same proc still fail to trigger hints.
Wierd... but not a deal breaker... I still LOVE using the tools. Makes SQL less of a chore to work with. / comments
Ed, Jack... thanks for the replies.
Unfortunately, I've been pulled to other non-db related tasks lately and haven't had time to explore more, but here are some facts/observations based on your rep...
I've now had the opportunity to check out more existing code (my product has over 500 procs) and I'm finding more procedures and functions that seem to have no problems displaying proper hints. Although the behavior doesn't seem to have any obvious reasons for existing. A table that fails to trigger a hint in one procedure triggers just fine on another. / comments
I've now had the opportunity to check out more existing code (my product has over 500 procs) and I'm finding more procedures and functions that seem to have no problems displaying proper hints. Alt...
Mouseover hints very inconsistent in existing queries
If I open an existing stored proc for editing in SSMS, some objects will show proper hints on mouseover, but others will not. Some observations:
* UDFs and builtin functions and stored procs will s...