Comments
Sort by recent activity
If you could check the log file and see if there are any exceptions in there that would be useful. It sounds like something is breaking the parser and that is causing your problems. I would be interested if you could disable SQL Prompt do one small change (like typing a letter) and then enable SQL Prompt. This should cause a full reparse. If it starts working again then it might be a bug in our change tracking. If it doesn't start working then there must be something in your script that is throwing it off.
Lionel / comments
If you could check the log file and see if there are any exceptions in there that would be useful. It sounds like something is breaking the parser and that is causing your problems. I would be inte...
Hi PDinCA
When I try to duplicate your issue my SQL Prompt seems to be picking up the changes to the table variable. In the Performance options tab on the options dialog under Listed Candidates there are some options that control the rescanning of the text. I suspect that your select statement is lower the the scanning range in that tab so the table variable is not being rescanned. If you write a select statement just below the Table variable does it pick up the changes ?
Lionel / comments
Hi PDinCA
When I try to duplicate your issue my SQL Prompt seems to be picking up the changes to the table variable. In the Performance options tab on the options dialog under Listed Candidates the...
Sorry again that you have run into this bug! You do not need to reboot but kill SSMS though task manager. If you email support@red-gate.com then they can give you a build that has this problem fixed. We are going to do a bit more testing on it before we make it public but if anyone has problems then they can email support and get this early version.
Lionel / comments
Sorry again that you have run into this bug! You do not need to reboot but kill SSMS though task manager. If you email support@red-gate.com then they can give you a build that has this problem fixe...
Hi
That is a known issue. I am looking into fixing it. Sorry for the inconvenience
Lionel / comments
Hi
That is a known issue. I am looking into fixing it. Sorry for the inconvenience
Lionel
If the files are not there then SQL Prompt should recreate them.
Lionel / comments
If the files are not there then SQL Prompt should recreate them.
Lionel
Hi that functionality is currently in our SQL Refactor product which is why it is not currently in SQL Prompt.
Lionel / comments
Hi that functionality is currently in our SQL Refactor product which is why it is not currently in SQL Prompt.
Lionel
I have sent you a personal message with it in. If you log in you should be able to check your inbox from the links on the top of the page.
Lionel / comments
I have sent you a personal message with it in. If you log in you should be able to check your inbox from the links on the top of the page.
Lionel
Hi thanks for reporting this. Is there any chance you could send me a personal message with that stored procedure in so we can reproduce that exception here?
Lionel / comments
Hi thanks for reporting this. Is there any chance you could send me a personal message with that stored procedure in so we can reproduce that exception here?
Lionel
Thanks a lot for the bug report I shall look into those problems.
Lionel / comments
Thanks a lot for the bug report I shall look into those problems.
Lionel
Thanks for the suggestion. We are defiantly considering this feature for the future.
Lionel / comments
Thanks for the suggestion. We are defiantly considering this feature for the future.
Lionel