Comments
Sort by recent activity
Hi @aisberg Please could you confirm which version of SQL Prompt you are using for SSMS and ADS. If you are running the latest versions for both (SSMS: 10.6.6, ADS: 0.2.6), you should be able to use the json files from the SSMS SQL Prompt directory in ADS. Thanks, Owen / comments
Hi @aisberg Please could you confirm which version of SQL Prompt you are using for SSMS and ADS. If you are running the latest versions for both (SSMS: 10.6.6, ADS: 0.2.6), you should be able to us...
Hi @NewGuy We've put in a change which should fix the case sensitivity problems you are experiencing with snippets. This will be included in SQL Prompt 10.6.7 which should be released next week. Thanks, Owen / comments
Hi @NewGuy We've put in a change which should fix the case sensitivity problems you are experiencing with snippets. This will be included in SQL Prompt 10.6.7 which should be released next week.Tha...
Hi, We've put in a fix for this which will be in SQL Prompt 10.6.5. This should be available later this afternoon. Thanks, Owen / comments
Hi, We've put in a fix for this which will be in SQL Prompt 10.6.5. This should be available later this afternoon.Thanks, Owen
Hi @TUellner This message shows when the SQL Server Data Tools extension is not installed into Visual Studio, which is required by SQL Prompt in Visual Studio. To install SSDT please follow the instructions here: https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15 Thanks, Owen / comments
Hi @TUellner This message shows when the SQL Server Data Tools extension is not installed into Visual Studio, which is required by SQL Prompt in Visual Studio. To install SSDT please follow the ins...
Hi @torsten.strauss The remove square brackets functionality removes square brackets where they are not necessary for the script to execute correctly. While this is sometimes against the Microsoft documentation best practice, this feature is completely optional within SQL Prompt and it is up to the user to decide whether they would like square brackets or not. The reason the last code block you shared does not remove the square brackets is because the first column has a space in the name and hence requires brackets, and the second column starts with a number and hence requires square brackets. CREATE TABLE test
(
[password test] nvarchar(100)
, [123delay] int NOT NULL
); I was able to replicate the expected behaviour in the latest version of SQL Prompt in SSMS, please feel free to open a support ticket if you are experiencing difficulties. It is worth noting that the behaviour between SSMS and VS for refactoring should be identical. Thanks, Owen / comments
Hi @torsten.strauss The remove square brackets functionality removes square brackets where they are not necessary for the script to execute correctly. While this is sometimes against the Microsoft ...
Hi, As far as I can tell from the documentation, password, delay, and object are not reserved keywords in transact SQL. They appear to be keywords, however they are not reserved words as mentioned in the Database identifiers article. https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver15 Thanks, Owen / comments
Hi, As far as I can tell from the documentation, password, delay, and object are not reserved keywords in transact SQL. They appear to be keywords, however they are not reserved words as mentioned ...
Hi @OlgaB While we do not officially support this use case, this should solve your problem:
Check in the new json files from one machine to your repository.
Delete the snippets from the other computers.
Pull down the new files from git on the other computers.
Once a snippet is created, the id doesn't change so there would be no problem editing them on different machines etc. Thanks, Owen / comments
Hi @OlgaB While we do not officially support this use case, this should solve your problem:
Check in the new json files from one machine to your repository.
Delete the snippets from the other com...
Hi everyone, We have just released SQL Prompt 10.6.1 which includes a fix for a performance issue introduced in 10.6.0. Please let us know if you experience problems once updated. Here's a link to the update: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.6.1.17779.exe Thanks, Owen / comments
Hi everyone, We have just released SQL Prompt 10.6.1 which includes a fix for a performance issue introduced in 10.6.0. Please let us know if you experience problems once updated. Here's a link to ...
Hi @Ropenfold SQL Prompt 10.5 and later use JSON files to store formatting styles. XML styles present in your styles directory will have automatically upgraded to the new format when upgrading to SQL Prompt 10.5. If you need to manually upgrade an older XML file please see this support article: https://documentation.red-gate.com/sp10/sql-code-formatting-and-styles/updating-style-files-from-before-version-10-5 Thanks, Owen / comments
Hi @Ropenfold SQL Prompt 10.5 and later use JSON files to store formatting styles. XML styles present in your styles directory will have automatically upgraded to the new format when upgrading to S...
Hi @SzymonOs We are due to release an update for SQL Prompt in ADS which should fix this issue - we will aim to release it today. Thanks, Owen / comments
Hi @SzymonOsWe are due to release an update for SQL Prompt in ADS which should fix this issue - we will aim to release it today. Thanks,Owen