How is SQL Prompt helping your team? Share your experience.
Problem importing new styles
ata0 Posts: 4 New member
in SQL Prompt
The support information says that when importing a new formatting style you should import a file ending in *.sqlpromptstyle. But when I try to import and go to the V2 folder on my local drive where styles are stored, I can only import a file ending in *.settings. More precisely it wants a file called prompt.settings. Help! I need to import a format style and cannot. When I import the prompt.settings I have, the format style remains unchanged.
0 · Share on Twitter
The documentation you've posted seems to be just for importing overall Prompt settings, not just formatting styles.
The correct way to grab a Prompt style out of an existing folder in v9 would be to go to SQL Prompt > Edit Formatting Styles in SSMS and use the [...] to select the correct folder with the styles in OR copy and paste the SQL Prompt style file into this same StylesV2 folder.
Let me know if this solves your issue!
What happens when you leave the files as they are and using the [...] button navigate to "...\AppData\Local\Red Gate\" and hit "Ok"? Even if the files aren't being found in the explorer they should be picked up!
Thanks for your post.
This looks like something a support engineer can investigate for you. If you have a support contract on your serial key then please do send us a ticket .
Thanks very much for your reply.
It was intended to let you know that you can get help here from the community but a support ticket is the official channel for sending us issues you might have.
I would also suggest that you can put the styles there on version 7 and then upgrade to V9 as an option to get around this.
I hope this is helpful.
Also, feel free to make any feature suggestions for future releases on our SQL Prompt Uservoice page in the link below.
Have a good weekend.
This might not always be relevant, but if you are importing a .sqlpromptstylev2 file from another computer and can't see it after setting it into the correct folder, the file might be blocked by windows as a security measure, just right click the styles file and go into properties and unblock it.
After that restart SSMS and it should appear.