Comments
Sort by recent activity
That sounds similar to what I am experiencing, but I'm not seeing it quite that bad. For instance it takes about 10 seconds when I select a window with a large/complex SP in it before SSMS is responsive to anything. / comments
That sounds similar to what I am experiencing, but I'm not seeing it quite that bad. For instance it takes about 10 seconds when I select a window with a large/complex SP in it before SSMS is respo...
Paul Stephenson wrote:
For a quick fix, we will be increasing the timeout in SQL Prompt 5.1 to five minutes (unless popular opinion here prefers a different value). If you are impatient to use this feature then please email me at paul.stephenson@red-gate.com and I'll send you a private patch.
When do you think 5.1 will be released? / comments
Paul Stephenson wrote:
For a quick fix, we will be increasing the timeout in SQL Prompt 5.1 to five minutes (unless popular opinion here prefers a different value). If you are impatient to use ...
PRN is a reserved file name in DOS/Windows that references your printer, so I suspect that is the problem.
I would have though having the ".sqlpromptsnippet" extension would have prevented the problem, but I guess not.
There are a number of other reserved names, for example COM1, LPT1, etc. that can't be used. / comments
PRN is a reserved file name in DOS/Windows that references your printer, so I suspect that is the problem.
I would have though having the ".sqlpromptsnippet" extension would have prevented the prob...
Yes, I had List system objects turned off, but technically a user created SP isn't a 'system object'. (SSMS doesn't list it in the 'System Stored Procedures' folder.) / comments
Yes, I had List system objects turned off, but technically a user created SP isn't a 'system object'. (SSMS doesn't list it in the 'System Stored Procedures' folder.)
Have you had a chance to try to replicate this yet? / comments
Have you had a chance to try to replicate this yet?
Anu Deshpande wrote:
Also you can use 'Enter' to insert the DISTINCT instead of DROP INDEX.
That would work if I used Enter as a completion key, which I don't. The double clicking does work though. / comments
Anu Deshpande wrote:
Also you can use 'Enter' to insert the DISTINCT instead of DROP INDEX.
That would work if I used Enter as a completion key, which I don't. The double clicking does work th...
Nope, I can't do that as I am using SSMS 2005, so there is no Intellisense to turn off. / comments
Nope, I can't do that as I am using SSMS 2005, so there is no Intellisense to turn off.
In your example the only valid suggestions I can come up with at line 5 would be ALL, DISTINCT, and TOP.
I agree it would be nice if it could offer suggestions, but how would they know when you were typing an alias, and when you were adding a new column if you don't supply the correct syntax? (i.e. the comma)
I run into too, but I am getting used to putting the comma in before adding a new column to the SELECT list now to avoid it. / comments
In your example the only valid suggestions I can come up with at line 5 would be ALL, DISTINCT, and TOP.
I agree it would be nice if it could offer suggestions, but how would they know when you wer...
The problem is that you have a query that doesn't have the correct syntax at that point.
If at line 5 you put a comma first, and then type PROD in front of the comma you will get the correct suggestions.
On line 7 it works because you have the comma in place already. / comments
The problem is that you have a query that doesn't have the correct syntax at that point.
If at line 5 you put a comma first, and then type PROD in front of the comma you will get the correct sugges...
SQL Prompt sort of has this, as you are typing the ()s it will highlight them. But for existing code you have to select the ( or ) and type over it and it will highlight the matching one. (It is sort of a pain, but it isn't as much of a pain as disabling SQL Prompt, and enabling Intellisense.) / comments
SQL Prompt sort of has this, as you are typing the ()s it will highlight them. But for existing code you have to select the ( or ) and type over it and it will highlight the matching one. (It is so...