Wednesday, March 28, 2012

importing trace data into table...

I follow the instructions to import text data from the link below:
http://support.microsoft.com/default...b;en-us;270599
but when i look at the trace_table, in the columb textdata, it's
NULL... where can i find the content?
Infact, the only columns that have data, is SPID, servername,
eventclass all other columns are NULL...
any help?
Tascien wrote:
> I follow the instructions to import text data from the link below:
> http://support.microsoft.com/default...b;en-us;270599
> but when i look at the trace_table, in the columb textdata, it's
> NULL... where can i find the content?
> Infact, the only columns that have data, is SPID, servername,
> eventclass all other columns are NULL...
> any help?
Did you include the textdata item in the trace? Was this a server-side
trace or are you saving a trace from Profiler?
David Gugick
Imceda Software
www.imceda.com
|||D'uh!
I missed that. yes, i did not include TextData in the columns...
thanks.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message news:<eyBlPXd1EHA.1408@.TK2MSFTNGP10.phx.gbl>...
> Tascien wrote:
> Did you include the textdata item in the trace? Was this a server-side
> trace or are you saving a trace from Profiler?
sql

No comments:

Post a Comment