I recently had received question if any stored procedure is encrypted can we see its definition in Activity Monitor.
Let us do quick test. Let us create following Stored Procedure and then launch Activity Monitor and check the text.
-- Create Encyrpted SP
CREATE PROCEDURE uspEnc
-- Execute SP
You will be not able to see the text of the encrypted Stored Procedure of the SQL Server.
What do you think? Is there any other way we can approach this?
Reference: Pinal Dave (http://blog.SQLAuthority.com)