Format "create certificate from binary "

rtieland

When formating a create certificate from binary statement with the following SQL code the formatter reports an error, is there a fix for this scenario.

CREATE CERTIFICATE MyCertificate AUTHORIZATION dbo FROM BINARY = 0x010101010101010101
WITH PRIVATE KEY ( BINARY = 0x010101010101010101 ,DECRYPTION BY PASSWORD = 'MyDecriptionPassword' );

squigley

Good Morning!
Just wanted to give you an update regarding this issue. The developers have looked into it and found out that this bug was actually present on both ours and Microsoft's end. They've implemented a fix which means Prompt should now correctly parse this script, and suggest `BINARY` when appropriate, however any refactorings will likely still fail, as they depend on the Microsoft ScriptDom parser. At this point unfortunately there isn't much we can do about this except wait for Microsoft to fix it on their end.

I apologize for the inconvenience that this brings.

Let me know if you have any other questions or concerns.

squigley

Good Afternoon!

Thanks for your inquiry and sorry to hear about your issue with SQL Prompt. My team and I were able to replicate this same error on our end. We'll escalate this to the developers and let you know of our next steps.

squigley

Good Afternoon!

Just wanted to give you an update that this has been fixed in the latest release:

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.0.8.13383.exe

Can you try upgrading to that version and see if that helps?

Thanks!

rtieland

The issue is indeed fixed for the suggestions, did you (Red-Gate) reported the Microsoft ScriptDom parser error to Microsoft?

squigley

I can confirm that we've informed Microsoft of this issue.

Please let me know if you have any other questions or concerns on your end.

Thanks!