Format "create certificate from binary "

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' );

Best Answer

  • squigleysquigley Posts: 169 Gold 1
    Accepted 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?


Sign In or Register to comment.