Thursday, September 10, 2015

decrypt Stored procedure

Create SP with encryption:
CREATE PROCEDURE Test
WITH ENCRYPTIONAS
SELECT TOP 
10 CityFROM Person.Address
GO



Now we cannot view the Definition of SP 



To view the definition of the view:I have downloaded below one and it worked excellent...

https://www.devart.com/dbforge/sql/sqldecryptor/download.html



Thanks to devart

1 comment:

  1. you can also take the help of SQL Server decryptor tool (http://www.dbpros.org/sql-server/decryptor.html) to remove encryption from your database

    ReplyDelete

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...