SQL SERVER – Encrypted Stored Procedure and Activity Monitor

[ERR!]
added by pinaldave
10/12/2010 12:15:52 AM

350 Views

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

Read the full story
Database SQL SQLServer SQLAuthority pinaldave
1 comments
sdorman
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.