Comments
Sort by recent activity
@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...
@SzymonOs We have just released a new version (v0.2.2) of the extension. Could you install that and see if it works? If not, there should be a log file in the following directory: C:\Users\[username]\.azuredatastudio\extensions\redgate.sql-prompt-0.2.2\logs\ Could you send that log file (or all of them is there are more than one) to sqlprompt.in.ads@red-gate.com and we'll investigate it further? / comments
@SzymonOs We have just released a new version (v0.2.2) of the extension. Could you install that and see if it works?If not, there should be a log file in the following directory:C:\Users\[username]...
@hlattanzio What you have done sounds correct. The AdsSnippets file should be the path to the file that ADS stores its user-specific SQL snippets in (usually C:\Users\hlattanzio\AppData\Roaming\azuredatastudio\User\snippets\sql.json). You can check this path by running Command palette -> Configure user snippets -> sql.json and then look at the path of the file that opens. The SSMSSnippetsFolder is the path to the folder that contains your snippets for SQL Prompt in SSMS (usually %localappdata%\Red Gate\SQL Prompt 10\Snippets). For both of these, you should be able to leave them as Default and the extension should still find them. If that isn't working, check what both paths are and set them explicitly in the ADS settings. If that still isn't working, can you drop us an email to sqlprompt.in.ads@red-gate.com? / comments
@hlattanzio What you have done sounds correct.The AdsSnippets file should be the path to the file that ADS stores its user-specific SQL snippets in (usually C:\Users\hlattanzio\AppData\Roaming\azur...
Yes, give that a try (make sure to put the path to the sql.json file in, not the directory). If that doesn't work, can you drop us an email to sqlprompt.in.ads@red-gate.com? / comments
Yes, give that a try (make sure to put the path to the sql.json file in, not the directory).If that doesn't work, can you drop us an email to sqlprompt.in.ads@red-gate.com?
Hi Simon, That's probably the SQL Prompt setting. There is a snippets file already within ADS for sql snippets. Could you check the path to that file using the the command palette: Command palette -> Configure user snippets -> sql [image] Adrian / comments
Hi Simon,That's probably the SQL Prompt setting. There is a snippets file already within ADS for sql snippets. Could you check the path to that file using the the command palette: Command palette -...
Hi Simon, Can you confirm the path to your Ads snippets file (Command palette -> Configure user snippets -> sql and then look at the path of the file that opens)?
Adrian
/ comments
Hi Simon,Can you confirm the path to your Ads snippets file (Command palette -> Configure user snippets -> sql and then look at the path of the file that opens)?
Adrian