SEO

#1 (**permalink**) 02-28-2008, 06:49 PM

I'm running SQL Profiler to analyze the queries being run against my
SQL server. The problem is, that in the Profiler results, the
TextData column, which contains the SQL statements executed, is
truncated so I don't get to see the entire SQL statements. I've gone
through all the documentation and menu options but I can't seem to
find a way to make it show me the entire SQL statement regardless of
length. Can anybody help?
Thanks,
Huey

#2 (**permalink**) 02-28-2008, 06:50 PM

If you log to a table or text file are you able to work with it?

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz

"Huey" <hughanderson4@yahoo.com> wrote in message
news:e5cf4d4b.0311171032.27b1c5be@posting.google.c om...
> I'm running SQL Profiler to analyze the queries being run against my
> SQL server. The problem is, that in the Profiler results, the
> TextData column, which contains the SQL statements executed, is
> truncated so I don't get to see the entire SQL statements. I've gone
> through all the documentation and menu options but I can't seem to
> find a way to make it show me the entire SQL statement regardless of
> length. Can anybody help?
> Thanks,
> Huey

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Profiler TextData truncation