Comments
Sort by recent activity
Hello AdrianG, Thanks for your post! SQL Source Control automatically refreshes the list of changes in the commit and get latest tabs. In order to improve performance, you'd have to add in the option yourself to disable auto refresh. For example, your UI Options .xml file might look like: <?xml version="1.0" encoding="utf-8" standalone="yes"?> <!----> <UIOptions version="1" type="UIOptions"> <CloseProgressDialogsOnCompletion>True</CloseProgressDialogsOnCompletion> <ShowTabOnSSMSStart>False</ShowTabOnSSMSStart> <AssemblyVersion>7.2.4.11418</AssemblyVersion> <PostAddToolTipDismissed>True</PostAddToolTipDismissed> <PostConflictInteractiveHelpShown>True</PostConflictInteractiveHelpShown> <PreviouslyLinked>True</PreviouslyLinked> <DisableAutoRefresh>True</DisableAutoRefresh> </UIOptions> I hope this answer helps you out! Don't hesitate to let me know if you have any other questions. / comments
Hello AdrianG,Thanks for your post!SQL Source Control automatically refreshes the list of changes in the commit and get latest tabs. In order to improve performance, you'd have to add in the option...
Hello @theDeveloper, If you were running SQL Prompt 9 (which had support for SSMS 2014, as described here) then updated to SQL Prompt 10 (which does not have support for SSMS 2014, as described here), that might be the reason why the extension is not appearing for you. Please uninstall the existing SQL Prompt, double check to make sure SSMS 18 is already installed, and then reinstall the latest version of SQL Prompt here. I hope this answer helps you out! Please do update me if you are still having any issues. @lorens, Can you provide me with your SSMS and SQL Prompt versions? It sounded like SQL Prompt previously worked for you, can include additional details of when this was no longer the case? Do you still see the SQL Prompt tab inside SSMS? / comments
Hello @theDeveloper,If you were running SQL Prompt 9 (which had support for SSMS 2014, as described here) then updated to SQL Prompt 10 (which does not have support for SSMS 2014, as described here...
Hi @FIRTHRO, Thanks for your post! Can you provide me with your SQL Prompt version? Per our release notes, this was a bug that should have been fixed as of SQL Prompt 10.3.2+. If you are on an older version of SQL Prompt, you can update by selecting SQL Prompt > Help > Check for Updates. I hope this answer helps you - please let me know if it does! Thank you, David Dang Product Support Engineer / comments
Hi @FIRTHRO,Thanks for your post! Can you provide me with your SQL Prompt version?Per our release notes, this was a bug that should have been fixed as of SQL Prompt 10.3.2+. If you are on an older ...
Hi @fpdave100, Thanks for reaching out! You've mentioned SP, are you referencing stored procedure? Also, can you help to clarify what you are trying to achieve with SQL Compare or what is the exact issue? Regarding the command DropAndCreateForReRunnableScripts (Legacy aliases: DropAndCreateInsteadOfAlter), SQL Compare replaces ALTER statements with CREATE or DROP statements so I'm not sure if there will be any impact running against CREATE statements. / comments
Hi @fpdave100,Thanks for reaching out! You've mentioned SP, are you referencing stored procedure? Also, can you help to clarify what you are trying to achieve with SQL Compare or what is the exact ...
Hello @SimonDorfman, Thanks for your post! Unfortunately, SQL Search does not support Azure SQL Data Warehouse. You'll find the supported environments on our requirements page below: https://documentation.red-gate.com/ss/requirements Thank you, David Dang Product Support Engineer / comments
Hello @SimonDorfman,Thanks for your post! Unfortunately, SQL Search does not support Azure SQL Data Warehouse. You'll find the supported environments on our requirements page below: https://documen...
Hi @bmay, Thanks for your patience! Great news! The spacing after "dbo" is fixed with the latest SQL Prompt 10.4.1 release here. The development team is still working on the second issue, where SET is missing the indent. / comments
Hi @bmay,Thanks for your patience!Great news! The spacing after "dbo" is fixed with the latest SQL Prompt 10.4.1 release here.The development team is still working on the second issue, where SET is...
Hi @bmay, Thanks for your patience! We've released SQL Prompt 10.4.2 release here which includes the fix for SET missing indent. Please don't hesitate to reach out if you have any other questions or feedback. / comments
Hi @bmay,Thanks for your patience!We've released SQL Prompt 10.4.2 release here which includes the fix for SET missing indent. Please don't hesitate to reach out if you have any other questions or ...
Hi @bmay, Thanks for your patience! Great news! The spacing after "dbo" is fixed with the latest SQL Prompt 10.4.1 release here. The development team is still working on the second issue where SET is missing the indent. / comments
Hi @bmay,Thanks for your patience!Great news! The spacing after "dbo" is fixed with the latest SQL Prompt 10.4.1 release here.The development team is still working on the second issue where SET is ...
Hello @rldawg, Unfortunately, there are currently no options or methods, and this would fall under a feature request. You can submit the feature request at Uservoice:
https://redgate.uservoice.com/forums/94413-sql-prompt
There is a similar existing feature request that you can vote on by commenting on having the option for using a SELECT instead of VALUES.
https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/38147416-multiple-format-options-for-insert-statements
As always, thanks for reaching out and using our products. Please let us know if you have any other questions or need additional help. Kind regards, David Dang Product Support Engineer / comments
Hello @rldawg,Unfortunately, there are currently no options or methods, and this would fall under a feature request. You can submit the feature request at Uservoice:
https://redgate.uservoice.com/f...
Hello, Based on the SQL Prompt options menu, the only option for INSERT statement is the VALUES clause. [image] I can escalate this to my team and provide you with an update. Thank you, David Dang Product Support Engineer / comments
Hello,Based on the SQL Prompt options menu, the only option for INSERT statement is the VALUES clause. I can escalate this to my team and provide you with an update.Thank you,David DangProduct Supp...