Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have set of queries executing from an ASP.NET application and I don't want those SQL queries to be traced by SQL Server Profiler. How can I do it?

share|improve this question
3  
Is that this query by any chance? dba.stackexchange.com/questions/55652/… –  Edward Dortland Jan 2 at 12:42
1  
So you didn't ask the framework team how to change query type? –  vonPryz Jan 2 at 13:25
    
The question is: Why do you want the queries to be hidden from Profiler? –  aaroncatlin Jan 2 at 16:23
    
This is the query that is using symmetric key with password for security purpose.i don't want anyone to profile my query and view the password. –  vijay Jan 3 at 4:45
    
Okay, so it is in fact still the same problem you are trying to solve as the link I gave in the first comment. Unfortunately, you can't "disable" profiler, and certainly not on a per query basis. Even if you could, any DBA could undo it. That's not the way to go. You need to solve your original problem (see first comment). To do that, I was kind enough to post a question on SO. stackoverflow.com/questions/20885953/…. Lets see what that brings us. –  Edward Dortland Jan 3 at 8:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.