InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 21:20:52 GMT20http://www.sqlservercentral.com/Forums/Topic1422186-391-1.aspxThanks for advise, I did not know about this function.So it sound like I have to create a job which on periodical basis will call this function and load trace file contents into a table, with specifying the last trace RowNumber from the table in order not to get duplicates. Not a perfect solution, but so far I could not find better one.Thanks again.Thu, 21 Feb 2013 10:13:24 GMTSQL Guy 1http://www.sqlservercentral.com/Forums/Topic1422186-391-1.aspxI don't think you *can* do it directly to a table, no--you have to use the fn_trace_gettable function to copy the trace file into a table.Thu, 21 Feb 2013 09:44:08 GMTpaul.knibbshttp://www.sqlservercentral.com/Forums/Topic1422186-391-1.aspxHi all,I created a trace in Profiler GUI. I set it to save results to a table and it is working good. But if I script trace definition, it does not provide anything to save it to table. System procedure sp_trace_create has only option to save to a file.Is it possible to save it to table at all with script or I am missing something? My version is 2008 R2.ThanksWed, 20 Feb 2013 10:16:16 GMTSQL Guy 1