Skip to content Skip to sidebar Skip to footer

Sql Server : Encrypt / Protect Stored Procedure

I am just wondering any good tools or software that you can recommend me to protect / encrypt my stored procedure that was developed on SQL Server 2008 R2 ? I read about create sto

Solution 1:

It's not free, but you could give SqlShield a try

SQL Shield is a built-in tool for MSSQL, SQL Express and MSDE servers that offers hacker-proof encryption for triggers, views and procedures

Solution 2:

Can't you use WITH ENCRYPTION? For example

CREATEPROCEDURE #EncryptSP
WITH ENCRYPTION
ASSELECT TOP 10 City
FROM Person.Address
GO

https://msdn.microsoft.com/en-gb/library/ms187926%28v=sql.105%29.aspx

Solution 3:

you can use dbforge decryptor for decryption.

Post a Comment for "Sql Server : Encrypt / Protect Stored Procedure"