Friday, March 9, 2012

Encrypt a stored procedure.

How might I encrypt a stored procedure in SQL server.
In sybase this is done with SP_HIDETEXT but SQL server doesn't appear to have this.
Is there another way?
Thanks,use WITH ENCRYPTION option wen you create SP, VIEW or UDF...
but it's useless...
fo details see BOL|||Calling it "Useless" is unnecessarily harsh.

FYI, the Hitchhiker's Guide to the Galaxy recently expanded its definition of SQL Enryption from "Useless" to "Mostly useless".|||Just a clairification:

CREATE PROCEDURE dbo.MyProcName WITH ENCRYPTION
as
...|||Well, it's surely an excellent way of protecting vendor's coding.|||Nope. The encryption scheme is pretty simple and was cracked some time ago. Decryption routines are readily available on the net.

No comments:

Post a Comment