September 18, 2008 at 12:31 pm
Okay, I'm running a trace in our beta environment (trying to track down a perf bottleneck) and I keep getting the following in the TextData column instead of the actual statement being executed:
-- 'password' was found in the text of this event.
-- The text has been replaced with this comment for security reasons.
I can pin down the statement by opening the stored proc and locating the line before it and the line after it. I know it's only a minor hassle but is there a way to turn this filtering off?
_____________________________________________________________________
- Nate
September 18, 2008 at 12:52 pm
Nope. In SQL Server 7, 2000 profiler doesn't include anything that includes the word password.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 18, 2008 at 1:57 pm
Which event is this? If you are grabbing stored procs, you'll get it. You can filter by database or user as well.
What does the proc do?
September 18, 2008 at 2:37 pm
Steve Jones - Editor (9/18/2008)
Which event is this?
SP: StmtCompleted
Issue comes up from time to time because of legacy code that uses @Password as an input parameter.
_____________________________________________________________________
- Nate
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply