8 Kicks

SQL SERVER – Encrypted Stored Procedure and Activity Monitor(blog.sqlauthority.com)

submitted by pinaldavepinaldave(9662) 1 year, 7 months ago

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

1 comment |category: |Views: 67

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
ssincero26ssincero26(0) - jeetjeet(0) - KarasbKarasb(0) - patelkhyati82patelkhyati82(0)
More who kicked this story...
Comments:

posted by sdormansdorman(1415) 1 year, 7 months ago 0

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.

Reply

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?