May 19, 2009 at 3:45 pm
I'm using profiler to analyze queries . When I'm trying to catch the login query the profiler instead displays:
-- 'password' was found in the text of this event.
-- The text has been replaced with this comment for security reasons.
is there any way that i can disable this option and capture the querry used
May 19, 2009 at 4:10 pm
As far as I know, no.
You'll be aware that Microsoft are trying to clamp down on 'back doors'
Ypu may be lucky though .. one of the super posters may contradict this tomorrow!
Sorry!
.
May 19, 2009 at 4:58 pm
Not as far as I'm aware.
In fact, it's a reasonably well known 'trick' to add "--password" to the end of a query to stop profiler from showing the code for that query. I'll leave it as an exercise to the reader to think of some reasons why you might want to do that.
What event are you tracing? If you're just looking for logins, try tracing the Audit Login event.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply