Options

Format "create certificate from binary "

rtielandrtieland Posts: 2 New member
in SQL Prompt
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' );




· Share on Twitter

Best Answer

  • Options
    squigleysquigley Posts: 231 Gold 1
    Answer ✓
    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.

    Sean Quigley | Product Support Engineer | Redgate Software

    Have you visited our Help Center?





    · Share on Twitter

Answers

Sign In or Register to comment.