Comments
Sort by recent activity
I can't believe you didn't get around to fixing this in 4.0.3... Any ideas when the next update will be? (And it appears that this issue has gotten assigned at least two IDs: SP-2796 and SP-2838) / comments
I can't believe you didn't get around to fixing this in 4.0.3... Any ideas when the next update will be? (And it appears that this issue has gotten assigned at least two IDs: SP-2796 and SP-2838)
It appears from what I have heard that Red Gate doesn't think this issue impacts many people, and it isn't slated to be fixed in version 5 that they are working on now. If you experience this bug and would like to see it fixed speak up now so that maybe they will add it to their list to fix. / comments
It appears from what I have heard that Red Gate doesn't think this issue impacts many people, and it isn't slated to be fixed in version 5 that they are working on now. If you experience this bug a...
robw wrote:
I'm talking about realizing that you need to open an existing stored procedure for editing. In the Eclipse example, when you hit CTRL-SHIFT-T, a new box opens up. You type a few characters, and matching classes come up. You pick the class, and it opens for editing.
Rob, have you tried out how SQL Prompt works?
* Open a "New Query" window in SSMS
* Type "AP" and hit TAB (should auto-complete to "ALTER PROCEDURE")
* Start typing your procedure name, select from the list and hit TAB
* SQL Prompt will pull the whole SP in ready for you to modify it.
I think that is essentially what you are trying to do. (The above assumes you have TAB setup as a completion key.)
The same works for Views and Functions, other than they don't have a pre-defined AV snippet for "Alter View" for some reason. / comments
robw wrote:
I'm talking about realizing that you need to open an existing stored procedure for editing. In the Eclipse example, when you hit CTRL-SHIFT-T, a new box opens up. You type a few chara...
JP7 wrote:
Ctrl + Shift + D didn't work.
Ctrl + Alt + S worked.
Out of curiosity I started SSMS from the menu while holding down Shift and it turned off SQL Prompt, so I assume that SSMS goes into "safe mode" when it detects that you started it with Shift held down. / comments
JP7 wrote:
Ctrl + Shift + D didn't work.
Ctrl + Alt + S worked.
Out of curiosity I started SSMS from the menu while holding down Shift and it turned off SQL Prompt, so I assume that SSMS goes i...
I think this is the same issue that someone else has reported: http://www.red-gate.com/MessageBoard/viewtopic.php?t=9407&highlight=nolock
Red Gate has acknowledged the problem and said they will fix it but in the mean time you can use "WITH (NOLOCK)" version and suggestions should work. / comments
I think this is the same issue that someone else has reported: http://www.red-gate.com/MessageBoard/viewtopic.php?t=9407&highlight=nolock
Red Gate has acknowledged the problem and said they will fi...
I don't think this issue has ever gotten fully identified, here is a sample that I think will help: DECLARE
@Name VARCHAR(1000),
@PageCount VARCHAR(1000);
SELECT
@PageCount = backed_up_page_count<CURSOR>
FROM msdb.dbo.backupfile;
SELECT<cursor2>
If you select <CURSOR> and type a comma and hit ENTER and then @ you will get no suggestions unless you hit ctrl-space.
However if you instead type a B you will get suggestions for field name automatically.
At cursor2 if you type a space you get no suggestions, but you should get the two variables suggested. / comments
I don't think this issue has ever gotten fully identified, here is a sample that I think will help:DECLARE
@Name VARCHAR(1000),
@PageCount VARCHAR(1000);
SELECT
@PageCount = bac...
OK, I think I figured the problem out, it is how I had SSMS setup, if you have it insert tabs instead of spaces backspace won't unindent a level.
Given that, I'm not liking the formatting that SQL Prompt does as much anymore, it converts the tabs to spaces, and then you can't unindent with backspace...
So I think that SQL Prompt needs to either:
* Unindent one level when you backspace at the beginning of a line
or
* Give an option to have the format SQL use tabs instead of spaces / comments
OK, I think I figured the problem out, it is how I had SSMS setup, if you have it insert tabs instead of spaces backspace won't unindent a level.
Given that, I'm not liking the formatting that SQL ...
I understand that it uses spaces, but I was pretty sure that in SQL Prompt 3 when you backspace it unindented one level. I really don't want to go back to SQL Prompt 3 just to verify that though. / comments
I understand that it uses spaces, but I was pretty sure that in SQL Prompt 3 when you backspace it unindented one level. I really don't want to go back to SQL Prompt 3 just to verify that though.
tanya wrote:
Hello,
Just a quick update, the cursor alignment issue is now fixed [image]
Thanks for the quick update, but it still isn't totally how I would expect it.
Given this:
SELECT
1 AS Field1,
2 AS Field2,
3 AS Field3
<cursor>
If I hit the back space key I expect it to either un-indent one level or back to the previous level, but it only removes one space. / comments
tanya wrote:
Hello,
Just a quick update, the cursor alignment issue is now fixed
Thanks for the quick update, but it still isn't totally how I would expect it.
Given this:
SELECT
1 AS Field...
All three options are set to UPPERCASE. / comments
All three options are set to UPPERCASE.