Encrypted Stored Procedure

How  to write a encrypted Stored Procedure?

Sometimes we  need to write a stored procedure so that alternative user cannot see written text within  Stored Procedure.

Even you may be ineffective to see the text of the encrypted Stored Procedure in SQL Server  Activity Monitor moreover as by using Sp_helptext SpName methodology.

So what's the command to write encrypted stored procedure.

Let See


CREATE PROCEDURE MyEncrypteSP_cnetcode
WITH ENCRYPTION
AS
SELECT *
FROM cnetcode.user
UNION
SELECT *
FROM cnetcode.user
GO
-- Execute SP
EXEC MyEncrypteSP_cnetcode
GO

:))