User profile for Dan_J

Hi again @Digga My apology, I should have asked you in my last post whether you are using Azure with MFA? / comments

Hi again @Digga My apology, I should have asked you in my last post whether you are using Azure with MFA?

0 votes

Hi @Bog My sincere apology for the delay in responding to you regarding this! So that I can best troubleshoot this, would you be happy to provide me with a copy of your script and format style file? / comments

Hi @Bog My sincere apology for the delay in responding to you regarding this!So that I can best troubleshoot this, would you be happy to provide me with a copy of your script and format style file?

0 votes

Hi @Bog Thanks for reaching out to us regarding this. Are you able to achieve the formatting you are after using the AND/OR operator settings shown in the screenshot below? [image] Regarding having to restart SSMS are formatting style changes, this shouldn't be necessary. What version of SQL Prompt are you currently using? / comments

Hi @Bog Thanks for reaching out to us regarding this.Are you able to achieve the formatting you are after using the AND/OR operator settings shown in the screenshot below? Regarding having to res...

0 votes

Hi Hanneke, My apology again for the delay in updating you on this! Unfortunately I will need the file in a json format, and so I will reach out to you by email via a ticket I have created. You will then be able to attach the file in your reply. / comments

Hi Hanneke,My apology again for the delay in updating you on this!Unfortunately I will need the file in a json format, and so I will reach out to you by email via a ticket I have created. You will ...

0 votes

Hi @Hanneke Thank you for your update on this, my sincere apology for the delay in responding to you! So that I can try and reproduce this at my end, would you be happy to send me a copy of of your format style? / comments

Hi @Hanneke Thank you for your update on this, my sincere apology for the delay in responding to you!So that I can try and reproduce this at my end, would you be happy to send me a copy of of your...

0 votes

Hi @Hanneke Thanks for reaching out to us regarding this. I think you should be able to achieve this by utilizing the Active Style List items options (as shown below)? [image] You may also need to adjust the Comma options, as shown below: [image] I hope this helps! Please do come back to us if you require any further assistance on this. / comments

Hi @Hanneke Thanks for reaching out to us regarding this.I think you should be able to achieve this by utilizing the Active Style List items options (as shown below)? You may also need to adjus...

0 votes

Hi @Mikael_H Thanks for your reply on this, my sincere apology for the delay in responding to you! I completely understand that unchecking Insert semicolons is not a good solution for you on this. I have had a further look through the SQL Prompt formatting options but unfortunately cannot find a way to achieve this. As a result, can I encourage you to raise this as a feature request via our User Voice system (https://redgate.uservoice.com/forums/94413-sql-prompt). Our development team will then review it alongside other submitted feature requests. / comments

Hi @Mikael_H Thanks for your reply on this, my sincere apology for the delay in responding to you!I completely understand that unchecking Insert semicolons is not a good solution for you on this. ...

0 votes

Hi @Mikael_H Thanks for reaching out to us regarding this, my apology for the delay in responding to you! I may need to raise this with our development team as a feature request, but before I do so, would you mind checking if the following helps? - Looking under the Styles options, unchecking 'Insert semicolons' will stop the semicolon being added after formatting. [image] I hope this helps, but please don't hesitate in coming back to us again if any further assistance is required on this. / comments

Hi @Mikael_H Thanks for reaching out to us regarding this, my apology for the delay in responding to you!I may need to raise this with our development team as a feature request, but before I do so...

0 votes

Hi @Gian Thanks for reaching out to us regarding this. The best way to achieve this is to create a new Style (SQL Prompt > Active Style > Edit Style) and, under the INSERT options, set 'Place subsequent columns on new lines' to 'Never', and select the desired brackets layout, as show in the screenshot below. You will need to do this for both the Column list and the Values list. [image] / comments

Hi @Gian Thanks for reaching out to us regarding this.The best way to achieve this is to create a new Style (SQL Prompt > Active Style > Edit Style) and, under the INSERT options, set 'Place subse...

0 votes

Hi @OffByOne Thanks for reaching out to us regarding this. @BrainDonor is correct, you can use SQL Compare to achieve what you're asking. To clarify, SQL Data Compare synchronizes the data, whereas SQL Compare synchronizes the schema. SQL Compare can be downloaded here: https://www.red-gate.com/products/sql-development/sql-compare/ . Your license should cover you to use this. / comments

Hi @OffByOne Thanks for reaching out to us regarding this.@BrainDonor is correct, you can use SQL Compare to achieve what you're asking. To clarify, SQL Data Compare synchronizes the data, whereas...

0 votes

How can we help you today?

Dan_J

Comments