• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 250
  • Last Modified:

stored proc not to be seen in profiler

how can we avoid the stored proc code being visible in profiler? (just need it for one stored proc)
0
25112
Asked:
25112
1 Solution
 
Surendra NathCommented:
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now