0
I need to decrypt some routines they’re using "WITH ENCRYPTION" and would like to know if there is any way by SQL Server itself, without needing to use third party tools, to do this.
0No answers
Browser other questions tagged sql-server
You are not signed in. Login or sign up in order to post.
Once encrypted, there is no direct way in SQL Server to decrypt the procedure. You may need to search the web to find third-party tools to decrypt them. Therefore, keep the source code of the object in a source control before executing the CREATE Object script with Encrypt option.
– Marco Souza
See http://www.mytecbits.com/microsoft/sql-server/encrypting-stored-procedure
– Marco Souza
Hello Marconcilio, I did not create, but I need to maintain many, and all functions, Views and Procedures are like this and I even tried to use Redgate SQL but it was trial and now I can’t use it anymore.
– Ricardo Souza
After a lot of research, I found someone who must have been through the same and decided to share. Follow the link https://www.dirceuresende.com/blog/sql-server-howto retrieve codigo-fonte-de-object-encrypted-with-encryption/
– Ricardo Souza
Just to confirm, the content of the link matches perfectly, does not display as a result just as message, but worked.
– Ricardo Souza