InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 13:02:23 GMT20http://www.sqlservercentral.com/Forums/Topic1234070-391-1.aspxUsing fn_trace_gettable you'll need to supply the file and path and the number of files to read. As below Load 10 files [code="SQL"]select * into my_trace from fn_trace_gettable('c:\mypath\mytrace.trc', 10)[/code]Load all files[code="SQL"]select * into my_trace from fn_trace_gettable('c:\mypath\mytrace.trc', default)[/code]Wed, 11 Jan 2012 13:19:19 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1234070-391-1.aspxYou can't write directly to a table with a server-side trace. Even if you could it wouldn't be wise as it would not perform as well as writing to a file and would have a negative impact on overall server performance.You get read the trace file using fn_trace_gettable([path to file]) and use that to load the trace data into a table if you want to do that.Wed, 11 Jan 2012 09:47:26 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic1234070-391-1.aspxThe link below helps me to create a server side trace to a file. I'd like to send the results to a table. Could some please tell me what change I need to make in the script to send the results out to a table?http://sqlserverpedia.com/wiki/The_Server-side_Trace:_What,_Why,_and_HowAnd also, I was told that server side tracing to a table in SQL 2000/2005 is different from SQL 2008. Is it?Wed, 11 Jan 2012 08:58:54 GMTsunny.tjk