I'm profiling a database just now and need to see the UPDATE and INSERT statements being executed on a particular table.
However, because the table has a 'Password' column the SQL Profiler is being understandingly cautious and replacing the
TextData column with:
-- 'password' was found in the text of this event.
-- The text has been replaced with this comment for security reasons.
How do I prevent it doing this because I need to see the SQL statement being executed?