Encrypted Stored Procedure in Sql Server 2008.

Encrypted stored procedure means no one can seen your create procedure statement. Encryption Convert original  sql server text of create procedure statement into a obfuscate formate. The output of obsfusacte formate is not visible by any of the catalog view in sql. User have no access to system table or database file .

This option is not valid for CLR stored procedure.

First Create a table ……..

Create table emp(empno int, empname varchar(50), empsal varchar(50));

Execute the code.

Now create procedure……

Create procedure sp_empDetails

With encryption

As

Select * from emp;

Execute the stored procedure

exec sp_helptext sp_empDetails

When you execute with above code (means using with sp_helptext) this will give a text message see figure below..

Please add your valuable comment. You can also add constructive information because it will improve the post infromation.