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 indeed sync your settings (and snippets) between installations of SQL Prompt. You’ll need to change the location that these files are stored in to either a synchronised location (such as a Dropbox or OneDrive folder) or a source controlled location (like a Git repository). Information about changing the locations that settings and snippets files are stored in can be found here: https://documentation.red-gate.com/disp ... et+folders We have had a UserVoice request for a more integrated solution. If that's something you'd find useful then please add your vote: https://redgate.uservoice.com/forums/94 ... ippets-etc Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Syncing Setting between to different computers
Hi You can indeed sync your settings (and snippets) between installations of SQL Prompt. You’ll need to change the location that these files are stored in to either a synchronised location (such ...
0 votes
Hi Thanks for posting. It looks like the forum might have stripped out some of the whitespace in your examples. We have a UserVoice request for controlling how nested IF ELSE statements are formatted here: https://redgate.uservoice.com/forums/94 ... ing-of-els If this looks like the same formatting style that you would like, please add your vote and you’ll get notified as soon as we release a build with this functionality included. We’re currently hard at work developing a new, more powerful formatting engine. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. formatting if else if statements
Hi Thanks for posting. It looks like the forum might have stripped out some of the whitespace in your examples. We have a UserVoice request for controlling how nested IF ELSE statements are formatt...
0 votes
Hi I assume this error message has been returned from an old query stored by Tab History. If the database has been renamed then the old credentials associated with that query will no longer work. You’ll need to manually connect to the renamed database before you can execute this query. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Unable to show database objects - table changed
Hi I assume this error message has been returned from an old query stored by Tab History. If the database has been renamed then the old credentials associated with that query will no longer work. Y...
0 votes
Hi ravendarksky Sorry to hear you’re having trouble getting the Developer Suite installed. Since that installer deals with multiple products, it’d be best to send an email to support@red-gate.com with this information. They’ll open a support ticket and work on troubleshooting any issues with you. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Cannot install, as part of SQL Developer Suite
Hi ravendarksky Sorry to hear you’re having trouble getting the Developer Suite installed. Since that installer deals with multiple products, it’d be best to send an email to support@red-gate.c...
0 votes
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
Total activity
91
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
35