Solved

stored proc not to be seen in profiler

Posted on 2013-06-26
1
240 Views
Last Modified: 2013-06-27
how can we avoid the stored proc code being visible in profiler? (just need it for one stored proc)
0
Comment
Question by:25112
1 Comment
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 500 total points
Comment Utility
you can set the encryption on for the stored procedure, and the code will not be shown in the profile.

just add WITH ENCRYPTION  before the as statement of your stored proceudre...
if you need to know more about Pros and cons of encryption, I suggest you to go over the below article

http://www.codeproject.com/Articles/38583/How-Do-I-Protect-My-Stored-Procedure-Code
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now