SQL SERVER – Encrypted Stored Procedure and Activity Monitor

added by pinaldave
10/12/2010 12:15:52 AM

7 Kicks, 193 Views

If you are using Encrypted Stored Procedure you not see them in Activity Monitor


10/11/2010 10:20:40 PM
Why are people still using encrypted stored procedures? I can't speak for SQL Server 2008 and later, but I know in earlier versions it was actually pretty easy to unencrypt them. As a result they really don't do much for security of your stored procedure and just make maintenance and troubleshooting that much more difficult.