How can we help you today? How can we help you today?
James R
Activity overview Badges (0) Posts (1) Comments (103)

Comments

Sort by recent activity
Hi @padigan, This is a known issue in the installer. If you right click on the top bar and select Log File..., can you send us the contents of the log? To fix the issue you need to navigate to %localappdata% and delete the Temp directory. If you re-run after doing that it should be fixed [image] Hope this helps! James / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 8 install problem on Windows 10
Hi @padigan, This is a known issue in the installer. If you right click on the top bar and select Log File..., can you send us the contents of the log? To fix the issue you need to navigate to %loc...
0 votes
Hi @Phil, Thanks for your post. Unfortunately SQL Prompt no longer supports SSMS 2008R2 and lower. You can upgrade your version of SSMS for free here Hope this helps! James / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt - Menu greyed out
Hi @Phil, Thanks for your post. Unfortunately SQL Prompt no longer supports SSMS 2008R2 and lower. You can upgrade your version of SSMS for free here Hope this helps! James
0 votes
Hi @Santosh_Mavuduri , Thanks for your post! Unfortunately when you install a new version of SSMS SQL Prompt does not automatically add itself so you will have to uninstall and reinstall SQL Prompt to get it to appear. Hope this helps! James / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt not available as menu option after upgrading Sql server 2012 to Sql server 2016.
Hi @Santosh_Mavuduri , Thanks for your post! Unfortunately when you install a new version of SSMS SQL Prompt does not automatically add itself so you will have to uninstall and reinstall SQL Prompt...
0 votes
Hi again @gvarol@corelogic.com , Just to let you know we've just released version 8.0.3.1587 of SQL Prompt which should fix this issue. Regards, James / comments
  1. Community
  2. SQL Prompt
  3. SQLPrompt fails to format a valid SQL (version 8.0.2.1508)
Hi again @gvarol@corelogic.com , Just to let you know we've just released version 8.0.3.1587 of SQL Prompt which should fix this issue. Regards, James
0 votes
Hi @gvarol@corelogic.com , Thanks for the post! I've managed to track this down to the CASE statement inside a select column list. If the WHEN clause has multiple conditions then the error occurs. We've logged the error here and will look into it this week. As a workaround for now you can go to SQL Prompt > Options > Format > Styles and uncheck the 'Apply column alias style' checkbox [image] Hope this helps! James / comments
  1. Community
  2. SQL Prompt
  3. SQLPrompt fails to format a valid SQL (version 8.0.2.1508)
Hi @gvarol@corelogic.com , Thanks for the post! I've managed to track this down to the CASE statement inside a select column list. If the WHEN clause has multiple conditions then the error occurs. ...
0 votes
Hi @jbrune, Thanks for noticing this! We've managed to reproduce this here, we'll hopefully investigate this week. Regards, James / comments
  1. Community
  2. SQL Prompt
  3. Bug in rename alias within a stored proc if select list calls a function
Hi @jbrune, Thanks for noticing this! We've managed to reproduce this here, we'll hopefully investigate this week. Regards, James
0 votes
Hi bunyamin , Thanks for your post. We've recently released version 8.0.2 of SQL Prompt which I think fixes this issue. You can download the update from inside SSMS by going to SQL Prompt > Help > Check for Updates or by downloading it here I hope this helps! James / comments
  1. Community
  2. SQL Prompt
  3. List items always added on new line
Hi bunyamin , Thanks for your post. We've recently released version 8.0.2 of SQL Prompt which I think fixes this issue. You can download the update from inside SSMS by going to SQL Prompt > Help > ...
0 votes
Hey again @torsten.strauss , We've just released version 8.0.3.1587 of SQL Prompt which should contain a fix for this issue [image] Hope this helps! James / comments
  1. Community
  2. SQL Prompt
  3. Error : laying out SQL
Hey again @torsten.strauss , We've just released version 8.0.3.1587 of SQL Prompt which should contain a fix for this issue Hope this helps! James
0 votes
Hi @torsten.strauss , Thanks for reporting this, it's an issue with the backwards compatible create index syntax (seen here ). We've got a fix for it here but as a workaround you can put the FILLFACTOR token in parenthesis and that should allow you to format [image] Hope this helps! James / comments
  1. Community
  2. SQL Prompt
  3. Error : laying out SQL
Hi @torsten.strauss , Thanks for reporting this, it's an issue with the backwards compatible create index syntax (seen here ). We've got a fix for it here but as a workaround you can put the FILLFA...
0 votes
Hi David, Thanks for noticing this! It's definitely a bug, I've found a fix here and will hopefully have it released in the next few days. I've logged this internally as SP-6361. Regards, James / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt introduces SCOPED CONFIGURATION errors
Hi David, Thanks for noticing this! It's definitely a bug, I've found a fix here and will hopefully have it released in the next few days. I've logged this internally as SP-6361. Regards, James
0 votes
Total activity
179
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
75