[dba-SQLServer]Querying on SQL trace log tables

Porter, Mark MPorter at acsalaska.com
Fri Dec 5 12:52:25 CST 2003

I'm trying to query on the query data provided by a SQL Trace, but SQL Trace
saves this data as an nText field.  Specifically, I'm monitoring the usage
of an application, and am trying to pull out relevant join and where clause
statements from the SQL which is hitting the database.

So far, all attempts to change to a varchar and pull out information have
failed or met with unexpected results.  I've used CAST and CONVERT, combined
with LEFT and RIGHT functions to pull data between keywords, but at best
I'll pull data from a different part of the statement.

Any ideas?

This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you. ACS

More information about the dba-SQLServer mailing list