How can we help you today? How can we help you today?
Ali D
Activity overview Badges (0) Posts (0) Comments (56)

Comments

Sort by recent activity
Hi You can specify custom date formats in the Snippet Manager, there's some more information here: https://documentation.red-gate.com/disp ... g+snippets The snippet you’re describing would look like this: edit $DATE(yyyy-M-dd)$ $TIME$ Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. i define this:DATE$ $TIME$,get 2016/2/11 . want 2016-2-11
Hi You can specify custom date formats in the Snippet Manager, there's some more information here:https://documentation.red-gate.com/disp ... g+snippets The snippet you’re describing would look l...
0 votes
Hi JesseT If I’ve followed your description correctly then unfortunately this is not currently possible to do in SQL Prompt. However, we are in the middle of overhauling SQL Prompt’s formatting engine to accommodate a much wider range of formatting styles. It’d be really useful to us if you could fill out our formatting options survey: https://www.surveymonkey.com/r/?sm=cvYX ... xkqA%3d%3d (You can fill it out as many times as you want) Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Formatting Help
Hi JesseT If I’ve followed your description correctly then unfortunately this is not currently possible to do in SQL Prompt. However, we are in the middle of overhauling SQL Prompt’s formatting...
0 votes
Hi WaldenL I’m glad to hear that’s got sorted out. With regards to coloring newly added servers to that of their parent group: whilst this would be nice to have, it wouldn't be reliable because there’s nothing to stop the same server appearing in multiple groups. This means there’s no guaranteed way of resolving the “correct†group for a newly added server. It’s possible to work around this limitation if your server groups have a naming scheme. For example, if your development servers all begin with “dev-â€, you can create a coloring rule for servers named “dev-*â€. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Coloring tabs by Group
Hi WaldenL I’m glad to hear that’s got sorted out. With regards to coloring newly added servers to that of their parent group: whilst this would be nice to have, it wouldn't be reliable because...
0 votes
Hi WaldenL Sorry to hear you’re having trouble with tab coloring. I think there might be some subtleties in this feature that’s catching you out. In the Registered Servers window, when you right click on a group there are two menu entries: Tab Color (Group) Tab Color (Servers in Group) It sounds like you’ve used Tab Color (Group) to set a color but this will only color a query window opened against the group itself. You can test this out by going to the Registered Servers window, right clicking on the group name and clicking New Query. If you want to every server in a group to have a colored tab, you need to use Tab Color (Servers in Group) menu option to set the color. Let me know how you get on. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Coloring tabs by Group
Hi WaldenL Sorry to hear you’re having trouble with tab coloring. I think there might be some subtleties in this feature that’s catching you out. In the Registered Servers window, when you righ...
0 votes
Hi stanac I've taken a closer look at this issue and we've got it logged with the tracking reference SP-2359. We intend to do some work on revamping the UI in future so keep an eye out for the tracking reference in subsequent releases. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. bug when resizing summarize script window
Hi stanac I've taken a closer look at this issue and we've got it logged with the tracking reference SP-2359. We intend to do some work on revamping the UI in future so keep an eye out for the trac...
0 votes
Hi stanac Thanks for getting in touch. I've been able to reproduce the issue you described, it seems to be happening in the column dependency window as well. We'll definitely take a look into fixing this in the new year. Hopefully you're able to work around this for the time being by resizing the window with the bottom right corner handle instead. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. bug when resizing summarize script window
Hi stanac Thanks for getting in touch. I've been able to reproduce the issue you described, it seems to be happening in the column dependency window as well. We'll definitely take a look into fixin...
0 votes
Hi opc.three This issue should now be fixed in the latest beta (7.1.0.234): https://forums.red-gate.com/viewtopic.php?f=169&t=78967 Please let us know if you have any issues with this build. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Error formatting MERGE statement in WHEN NOT MATCHED BY
Hi opc.three This issue should now be fixed in the latest beta (7.1.0.234): https://forums.red-gate.com/viewtopic.php?f=169&t=78967 Please let us know if you have any issues with this build. Thanks...
0 votes
Hi opc.three Sorry for the confusion, we think we’ve now been able to reproduce this issue and we’ll look into improving this. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Error formatting MERGE statement in WHEN NOT MATCHED BY
Hi opc.three Sorry for the confusion, we think we’ve now been able to reproduce this issue and we’ll look into improving this. Thanks Ali
0 votes
Hi vsha041 I’m sorry to hear that you’re having trouble with this feature. I’ve tried to reproduce the issue on an identical set up to yours but the problem isn’t occurring for me. There are a few things that could be going on here: Just to check before we go any further, is the caret inside the block you want to execute before you press Shift+F5? (see this video for more information: https://youtu.be/BqHZ4wqh_Ko?t=40 ). It’s possible that something else has bound to this keyboard shortcut. To find out whether this is the case, inside SSMS go to Tools > Options > Keyboard and filter the commands list by ‘ExecuteCurrentStatement’. Is the shortcut for the 'RedGate.SQLPrompt.SSMSUI.Connect2011.ExecuteCurrentStatement' command ‘Shift+F5 (SQL Query Editor)' ? If the shortcut is different you can manually change this shortcut back to Shift+F5 which should fix the problem. After restarting SSMS, the shortcut may revert to whatever had stolen it in the first place. If this is the case then we can make a configuration change to force SQL Prompt to rebind its shortcuts on start up. If the shortcut in the Options window is not different then can you see the 'Shift+F5' key binding list next the context menu item for Execute Current Statement when you right click on a statement? Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt Shift + F5 Issue
Hi vsha041 I’m sorry to hear that you’re having trouble with this feature. I’ve tried to reproduce the issue on an identical set up to yours but the problem isn’t occurring for me. There ar...
0 votes
Hi Aaron If the network folder is unavailable when SQL Prompt starts up then it will revert to using its default snippets folder. We've had a few customers successfully share their snippets in a source controlled location, like a Git or Mercurial repository. Another option is to store your snippets folder in a synchronised location, such as a Dropbox or OneDrive folder. These may be better solutions if your network share is not consistently available. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Snippet Repository resetting to default
Hi Aaron If the network folder is unavailable when SQL Prompt starts up then it will revert to using its default snippets folder. We've had a few customers successfully share their snippets in a so...
0 votes
Total activity
91
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
35