689 results found

1. Warn if comparing column to itself in WHERE clause

   I would love a warning to prevent the classical mistake of comparing a column with itself instead of with another column in a WHERE clause.

   An example is the following, where I would like a warning where one has "qlpd.interimdisbursementid = qlpd.interimdisbursementid" as it should be qlpd.interimdisbursementid = di.interimdisbursementid instead:
   SELECT *
   FROM dbo.datinterimdisbursement AS di
   INNER JOIN dbo.qlirologPayoutServicedata qlpd
   ON qlpd.interimdisbursementid = qlpd.interimdisbursementid;

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

2. Copy (just) 1 or more headers from result

   I would like the ability to select 1 or more values in a result and have the (right-click?) option to select header(s). I then have the header, or headers separated with commas in my clipboard.

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

3. Search for column in result

   I would LOVE! the ability to have a search window with my results from a query, where I type in any part of a column name and it lists all columns containing value I typed in.
   By default one is positioned on the applicable column in the result (scrolling if necessary in wider result set), but if one clicks on any column matching value then it positions one on that column in the result.

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Find invalid objects  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

4. FREEZES SSMS - Add what tool (name) caused the error to the title of an error window

   The error popup comes out of nowhere when navigating SSMS tree nodes, notably when selecting a specific database name. I expected it came from SQL Prompt, but there was nothing being logged even when verbose option has been enabled.

   The support helped clarify it "probably" came from SQL Source Control installed recently.

   Also, the "Send Error Report" never worked.

   The error completely freezes SSMS as it is a modal.

   It has to be dismissed multiple times and then navigated away from the selected database back to a server's name - quickly using a keyboard.

   •  

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  User interface  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

5. don't do auto completion when renaming

   When renaming a table alias, or a variable, sometimes you want to rename it to something and SQL Prompt will intercept the return key (to accept the rename) and "auto correct" it - for example, this morning I wanted to change a table alias to "l" and it auto corrected this to "LEFT", so I had to change it back and press enter again.

   It's not a big thing, just it happens quite a lot and can be aggravating.

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  User interface  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

6. "Prompt AI" allow more database objects, or a defined lists of schemas

   Tried to test out the new Prompt AI feature and cannot use it to generate SQL as the DB has more than 4000 objects (over 6000 actually). It would be great to limit the schemas within the DB where I want the AI tool to "know about" so that A) it keeps the AI focused on just the schemas it needs to answer most questions and B) it keeps the overall list of objects and time needed to poll them more manageable. In absence of this, allow more objects.

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

7. Refactoring: Convert expression to cross apply

   Working with a query that contains the same expression multiple times, I often want to extract all instances of that expression into a CROSS APPLY for readability and ease of modification, e.g. converting something like this horribleness:

   select foo = case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end, count(*)
   from baz
   where case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end in ('a','b')
   group by case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end

   into something more manageable like this:

   select x.foo, count(*)
   from baz
   cross apply (
   values(case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end)
   ) x(foo)
   where x.foo in ('a','b')
   group by x.foo

   I would love to be able to highlight such an expression, right-click, and have a SQL Prompt option for "Convert expression to CROSS APPLY (replace all instances)", similar to Visual Studio's "Introduce Local" refactoring.

   Working with a query that contains the same expression multiple times, I often want to extract all instances of that expression into a CROSS APPLY for readability and ease of modification, e.g. converting something like this horribleness:

   select foo = case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end, count(*)
   from baz
   where case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end in ('a','b')
   group by case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end

   into something more manageable… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

8. SQL History - Recent query list filenames - increase number of characters displayed before truncation

   This is a minor inconvenience, but one with multiple potentially easy solutions. When using SQL History, I find that the "Recent queries" filenames become truncated very early due to the large font size and having only a single row of text used for displaying them. There is also a chunk of free space / padding to the right side that seems to be wasted (see orange arrow in my 2nd screenshot).

   Given the naming convention that I tend to use with my saved scripts ("date - internal ticket # - brief script description/purpose"), I often only see the date and ticket #, so there may be several queries in a row that appear to be named the same at first glance.

   If I horizontally drag to widen the Recent query pane to reveal more/all of my script files' names (as shown in my first screenshot), I then give up space on the query preview pane to the right. This results in a constant dragging of the Recent query list back and forth while navigating through the list and previewing the T-SQL.

   There are multiple potential ways I can think of to address this to varying extents:

   1. Reclaim the extra padding pointed out in my 2nd screenshot -- this at least gives room for perhaps one more word or two to be displayed.

   2. Add a setting to reduce the font size of "Recent queries" filenames (or just reduce it down to something like the size of the timestamp shown below it in gray to buy more space without having to add a whole new setting).

   3. Vertically expand the filename text area slightly and allow the filename to word wrap onto a second or even third line (or better yet, enable the user to vertically drag to resize as they desire, but this would probably require more dev time).

   [Edit: note that my attached screenshots' orders got uploaded in reverse order (so when I say "1st screenshot" above, it means the second/right-hand side one with a 40 KB size). Just adding for clarification.]

   Thanks!

   This is a minor inconvenience, but one with multiple potentially easy solutions. When using SQL History, I find that the "Recent queries" filenames become truncated very early due to the large font size and having only a single row of text used for displaying them. There is also a chunk of free space / padding to the right side that seems to be wasted (see orange arrow in my 2nd screenshot).

   Given the naming convention that I tend to use with my saved scripts ("date - internal ticket # - brief script description/purpose"), I often only see the date and… more

   •  

   •  

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  User interface  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

9. Add Connection color to Object Explorer

   Dealing with multiple servers via the connection coloring is great, but looking at the object explorer while you are drilled down into things often has me scrolling to figure out what server I'm really looking at. Could we get a color bar in the object explorer that would simply have the color designated for the server.

   It would make it easier to tell what environment I'm looking at.

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  User interface  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

10. make update notification window resizable or autosize with Windows zoom

    I like to use the Windows zoom feature to make text bigger. (Not the dpi size feature, but rather the text size feature listed above the dpi setting.)

    With this increased, I cannot see the links in Red Gate update notification windows. I'll open SSMS and get a notification for prompt that I am running 1.0.7 and the latest version is 1.0.8. There is a details link that allows me to upgrade. I can also upgrade by downloading the latest version of the tools from the Red Gate web site.

    However, for minor upgrades, I often skip the upgrade process since the bugs fixed likely do not pertain to my experiences. And that's where the inability to see the links at the bottom of the notification (remind me tomorrow, skip this update) is an issue for me. I can't see those links, and so I can't click "skip this upgrade", and so I get the notification every time I open SSMS. (I think the same may pertain to other tools such as Compare and Data Compare.) I can x-out the notification window, but I can't tell it to not reappear for this update.

    I would like the notification window to be resizable (or else auto scale with the Windows text zoom feature).

    I like to use the Windows zoom feature to make text bigger. (Not the dpi size feature, but rather the text size feature listed above the dpi setting.)

    With this increased, I cannot see the links in Red Gate update notification windows. I'll open SSMS and get a notification for prompt that I am running 1.0.7 and the latest version is 1.0.8. There is a details link that allows me to upgrade. I can also upgrade by downloading the latest version of the tools from the Red Gate web site.

    However, for minor upgrades, I often skip the upgrade process… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

11. Show Code Window Even if Schema is Missing

    When I scroll over an object *table, view, function, stored procedure), SQL Prompt typically displays a tooltip that describes what the object is (e.g. Table). I can click on the tooltip and see a script of the object.

    However, if I have not included the schema, then I do not get the tooltip, but rather a warning that "Schema name for table or view is not specified" and I am not able to view the object code without either disabling that alert or adding the schema name.

    While it may be advantageous to have this rule enabled, it would also be beneficial to view the object code when the object's schema name is not present.

    When I scroll over an object *table, view, function, stored procedure), SQL Prompt typically displays a tooltip that describes what the object is (e.g. Table). I can click on the tooltip and see a script of the object.

    However, if I have not included the schema, then I do not get the tooltip, but rather a warning that "Schema name for table or view is not specified" and I am not able to view the object code without either disabling that alert or adding the schema name.

    While it may be advantageous to have this rule enabled, it would also… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

12. Toggle SQL Prompt Suggestions

    I love the immediate suggestions when I need/want them, however when I do not want them, the suggestion box ends up blocking my screen more than it helps (Often blocking code I want to reference in a future query) and there is not a good way to make the suggestion box go away without clicking away from wherever it was suggesting.

    I know I can delay the popup and manually show suggestions with ctrl+space, but I would love to be able to manually hide them as well with ctrl+space as a simple toggle. It would greatly help me and other SQL developers in my department.

    I love the immediate suggestions when I need/want them, however when I do not want them, the suggestion box ends up blocking my screen more than it helps (Often blocking code I want to reference in a future query) and there is not a good way to make the suggestion box go away without clicking away from wherever it was suggesting.

    I know I can delay the popup and manually show suggestions with ctrl+space, but I would love to be able to manually hide them as well with ctrl+space as a simple toggle. It would greatly help me and other… more

    4 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  User interface  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

13. Add a “Save Results As” Excel option

    This is needed because I am required to run SSMS with elevated rights.

    My regular Windows login doesn't have access to my database servers, and my elevated account doesn't have access to my MS 365 office suite.

    Because of this, the "Open in Excel" feature is not useable.

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

14. HoverOver Popup Incorrect

    Using SSMS 21.4.8 and SQL Prompt 11.0.6.17341.

    Using a derived select to retrieve data then derive select that to change the data types then a third derived select to present the data.

    In the inner most SELECT, the fields OrderID and OrderItemID are Integer in both the the Microsoft and SQL Prompt HoverOver popups.

    In the outer most SELECT, the OrderID and OrderItemID are Varchar in the Microsoft HoverOver popup but Integer in the SQL Prompt HoverOver popups.

    Also in the outer most SELECT, down in the ORDER BY, they show differently hovering over between the Microsoft and SQL prompt HoverOver popups.

    The SQL text shows the problem. Run the script then come in and hover over the OrderID and OrderItemID fields in the different places in the SELECTs.

    HoverOver1.png shows how it looks on the Inner most SELECT. Both are Int.
    HoverOver2.png shows how it looks on the Outer most SELECT. Microsoft is varchar and SQL Prompt is Int.

    Using SSMS 21.4.8 and SQL Prompt 11.0.6.17341.

    Using a derived select to retrieve data then derive select that to change the data types then a third derived select to present the data.

    In the inner most SELECT, the fields OrderID and OrderItemID are Integer in both the the Microsoft and SQL Prompt HoverOver popups.

    In the outer most SELECT, the OrderID and OrderItemID are Varchar in the Microsoft HoverOver popup but Integer in the SQL Prompt HoverOver popups.

    Also in the outer most SELECT, down in the ORDER BY, they show differently hovering over between the Microsoft and SQL prompt… more

    •  

    • 

    •  

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

15. Alignment of nulls

    How can we get the following alignment with nulls? Please review the pre & post images attached

    •  

    •  

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

16. Keyword KEEP_CDC not recognized in RESTORE statement

    Add support for the KEEP_CDC keyword. Example:

    RESTORE DATABASE MyDB
    FROM  DISK = N'\\SOMEWHERE\MyDB_FULLBACKUP1.BAK'
    WITH FILE = 1,
    MOVE N'MyDB_DATA' TO N'M:\SQLData1\SQL_DATABASE\MyDB.MDF',
    MOVE N'MyDB_LOG' TO N'M:\SQLLogs1\SQL_DATABASE\MyDB_LOG.LDF',
    RECOVERY, REPLACE, STATS = 1, KEEP_CDC, NEW_BROKER, RESTRICTED_USER
    

    Currently the formatting process errors out.

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

17. Add IntelliSense/AutoComplete Support for ALTER ROLE...ADD/DROP MEMBER Statement

    I originally submitted this as a support case when I saw that there was no IntelliSense suggestions when writing an ALTER ROLE...ADD MEMBER or ALTER ROLE...DROP MEMBER statement (the former doesn't show potential users/groups for completion and the latter doesn't show current role members for completion), but after investigation on the Redgate side I was told this was a feature that was never implemented.

    It would be great if we could get support added for this please, as ALTER ROLE is a core statement that has been around for many versions, and also because the alternative methods (e.g. spaddrolemember and spdroprolemember sprocs) are deprecated now and MS recommends the use of ALTER ROLE instead.

    Thank you in advance for your consideration.

    I originally submitted this as a support case when I saw that there was no IntelliSense suggestions when writing an ALTER ROLE...ADD MEMBER or ALTER ROLE...DROP MEMBER statement (the former doesn't show potential users/groups for completion and the latter doesn't show current role members for completion), but after investigation on the Redgate side I was told this was a feature that was never implemented.

    It would be great if we could get support added for this please, as ALTER ROLE is a core statement that has been around for many versions, and also because the alternative methods (e.g. spaddrolemember… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

18. Colorize vertical tabs

    Tab coloring doesnt work in vertical tabs mode

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Tab coloring  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

19. Option to hide "find invalid object" menu

    This feature crash SQL Server because our procedures multi-databases, encrypted and so-one and not a needed feature. But the menu is misclicked lot of times and crash SQL Server.
    Could you please, add an option to hide "find invalid object" menu

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Find invalid objects  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

20. Automate replacing variables with literals for troubleshooting stored procedures

    Quite often when troubleshooting a stored procedure, it is helpful to step through it and run each statement individually. In stored procedures that take parameters, though, you need to manually swap out the variable name for a test value in each statement, or put variable declarations and sets in front of each statement.

    It would be convenient if SQL Prompt could automate this process. It could check for parameters, prompt the user to provide values for them, then do the variable-to-literal substitution throughout the code. It could then provide an easy way to reverse the change to support committing the edited code.

    Quite often when troubleshooting a stored procedure, it is helpful to step through it and run each statement individually. In stored procedures that take parameters, though, you need to manually swap out the variable name for a test value in each statement, or put variable declarations and sets in front of each statement.

    It would be convenient if SQL Prompt could automate this process. It could check for parameters, prompt the user to provide values for them, then do the variable-to-literal substitution throughout the code. It could then provide an easy way to reverse the change to support committing the… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Code Analysis  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating