Comments
Sort by recent activity
@SzymonOs @Emanuel_B The link above should get you the latest version, but it does have a cache expiry on it, so you might be hitting that. The direct download link is: https://download.red-gate.com/EAP/SQLPromptADS/SQLPromptADS_0.2.4.0.zip. / comments
@SzymonOs @Emanuel_B The link above should get you the latest version, but it does have a cache expiry on it, so you might be hitting that. The direct download link is: https://download.red-gate.co...
@SzymonOs Thanks for letting us know. We've tracked down the problem and released v0.2.4 that should fix the issue. / comments
@SzymonOs Thanks for letting us know. We've tracked down the problem and released v0.2.4 that should fix the issue.
This issue has now been fixed. The fix is available in SQL Prompt v10.4.4. / comments
This issue has now been fixed. The fix is available in SQL Prompt v10.4.4.
@... Unfortunately, that is how 3rd party (i.e. non-Microsoft) extensions have to be installed in ADS. This is different from how extensions are installed in VS Code (if you are familiar with that). When you click the install button in ADS, a zip file with the VSIX will be downloaded. To install it into ADS, you will need to do it manually. To do this: 1. Click on the extensions tab, open the menu at the top and choose "Install from VSIX...". [image] 2. Choose the SQL Prompt for ADS VSIX file that you downloaded. 3. You will then get a message about installing a third party extension. Click "Yes" to install the extension: [image] 4. You should then get a confirmation message that the extension has been installed successfully: [image] / comments
@... Unfortunately, that is how 3rd party (i.e. non-Microsoft) extensions have to be installed in ADS. This is different from how extensions are installed in VS Code (if you are familiar with that)...
Hi @aisberg, Could you consider publishing the complete list of all possible settings for formatting?
If you look in the SQL Prompt extension's installation directory (usually in C:\Users\[username]\.azuredatastudio\extensions\), there is a file inside the Styles directory called full-style.json.example that contains all options and all possible values. There is a schema for the json file in that directory as well, in case you are using a tool that supports it. / comments
Hi @aisberg,Could you consider publishing the complete list of all possible settings for formatting?
If you look in the SQL Prompt extension's installation directory (usually in C:\Users\[username]...
@DeeTron Thanks for letting us know. That is indeed a typo. It's now been fixed and will be released in the next version of the ADS extension. / comments
@DeeTron Thanks for letting us know. That is indeed a typo. It's now been fixed and will be released in the next version of the ADS extension.
@DeeTron When creating the style file, there should be in-built help that pops up within the file itself as you are typing: [image] [image] You can trigger it by pressing Ctrl+Space in the file. If there are any settings that you are not clear on, please don't hesitate to ask for further help. / comments
@DeeTron When creating the style file, there should be in-built help that pops up within the file itself as you are typing:You can trigger it by pressing Ctrl+Space in the file.If there are any set...
@JustinLezon The snippet converter isn't doing anything special (as in needing special permissions). It reads the snippets from the SSMS directory, converts them to a different format, and then saves them into the ADS json file. Given the error you are getting, it seems to be more of an environment issue relating to users/permissions. I'd suggest checking that the user you are running the converter as has access to both paths you are giving it. It might also be worth checking that the SSMS path is to a directory containing snippet files, and the ADS path is a file path of the sql.json file of ADS. / comments
@JustinLezon The snippet converter isn't doing anything special (as in needing special permissions). It reads the snippets from the SSMS directory, converts them to a different format, and then sav...
@JustinLezon When the SQL Prompt ADS extension starts, it runs a command line to do the import of snippets. Could you try to run the importer manually? To do so, find the directory in which the extension is installed (usually C:\Users\<username>\.azuredatastudio\extensions\redgate.sql-prompt-0.2.6\out\SnippetConverter) and run: SqlPrompt.SnippetConverter.exe --ssmsSnippetsFolder <path to SSMS snippets directory> --adsSnippetsFile <path to ADS snippets file> Do you get the same error? / comments
@JustinLezon When the SQL Prompt ADS extension starts, it runs a command line to do the import of snippets. Could you try to run the importer manually?To do so, find the directory in which the exte...
@JustinLezon The error suggests that it is a file permission problem: <div>System.UnauthorizedAccessException: Access to the path 'C:\Users\lezonj\AppData\Roaming\azuredatastudio\User\snippets' is denied.</div><div></div> Can you confirm that you have access to that path? / comments
@JustinLezon The error suggests that it is a file permission problem:<div>System.UnauthorizedAccessException: Access to the path 'C:\Users\lezonj\AppData\Roaming\azuredatastudio\User\snippets' is d...