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
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
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