InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 08:03:59 GMT20http://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxHi chinn,I am looking for a similar solution that you were looking for. Could you let me know how you were able to accomplish the automation of loading trace files to a table?Thanks!Mon, 07 Jan 2013 08:34:08 GMTPrakash.Bhojegowdahttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxThanks Very Much For You Prompt replies.Thanks Again...Fri, 31 Jul 2009 13:25:28 GMTchinnhttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxYou'll have to re-create it. I set them to do that in an auto-start proc that fires off when the SQL service starts.Fri, 31 Jul 2009 12:36:35 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxThe trace definition is deleted. You will need to recreate it and restart it. If this is something you always want running you may want to encapsulate it in a stored procedure and mark the stored procedure for startup. Here's a [url=http://msdn.microsoft.com/en-us/library/aa214405(SQL.80).aspx][u]link[/u][/url] for that. Or you can put it in a job that runs on startup.Fri, 31 Jul 2009 12:36:34 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxGuys,One quick question...When running Server Side Tracing...if we restart sql server ..Do i need to just start the existing traceor Recreate the TraceIn other words..will the trace be stopped or closed(deletes the definition)Thanks,Fri, 31 Jul 2009 12:28:55 GMTchinnhttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxThanks...Very Much!I got an idea from your previous post...Thanks for you help!Thu, 30 Jul 2009 07:08:48 GMTchinnhttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxTry this for a list of the files:[code]create table #T (ID int identity primary key,FName varchar(256));--insert into #T (FName)exec master..xp_cmdshell 'dir MyTraceDirectory\*.trc /b';--select *from #T;[/code]You'll have to put in the actual directory, of course.Once you have that list, it should be very easy to select everything except the last file, and to load up the trace table from that. It's easier in SQL 2005, because you could construct a simple Except argument, but it's not that difficult in 2000 to set up a comparable outer join or Where Not In.That should give you what you need, right?Thu, 30 Jul 2009 06:50:39 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxLowell,That script is 2005/2008 specific and this is a 2000 forum. You'd have to modify the script to use Scott's solution to get the path.Wed, 29 Jul 2009 10:17:00 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxthere is a script submission that loads all the trace files into a table here:[url=http://www.sqlservercentral.com/scripts/SQL+Trace/65790/]Default Trace Load of All 5 Files[/url]you could easily change the command from '*.trc" to logins*.trc" to get all the specific ones you were looking for.Wed, 29 Jul 2009 07:36:50 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxHello,Is there a way we can do that Programatically.Ignore the file that is being used...Thanks,Wed, 29 Jul 2009 07:28:54 GMTchinnhttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxIf you query a list of the files, it would be very easy to not use the last one in the list. That's why I suggested that.Wed, 29 Jul 2009 07:22:07 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxHello All....Thanks For Your Inputs...But my question is how do i Know..which one is currently being used or written to because i want to ignore that and load the rest of them into a table.For example...C:\trace\logins.trc---current one 0 bytes..c:\trace\logins1.trcC:\trace\logins2.trc...i want to ignore logins.trc file because if i include that it(loading of trace files) will fail.Thanks....Wed, 29 Jul 2009 06:08:55 GMTchinnhttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxYou can get the trace file names in use from fn_trace_getinfo, assuming you know the traceid. [code]SELECT valueFROM fn_trace_getinfo( @traceid )WHERE property = 2[/code]Or if the traceid is uncertain but the base filename is known you could try[code]SELECT valueFROM fn_trace_getinfo(0)WHERE property = 2 AND value LIKE '%filename%'[/code]Tue, 28 Jul 2009 18:30:38 GMTScott Colemanhttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxwhy not create a view, so it is always ready on demand?CREATE VIEW MyTrace AsSelect * from FROM ::fn_trace_gettable(c:\my_trace.trc", default)Tue, 28 Jul 2009 15:29:25 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxYou can use xp_cmdshell to query the files in a directory. Would that allow you to do what you want?Tue, 28 Jul 2009 15:05:06 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic761110-5-1.aspxHello,We run profiler traces for auditing logins and i am using server side tracing and everything works great.I just want to automate loading of trace files into a table without stopping trace..i know i cant use this...SELECT * INTO temp_trcFROM ::fn_trace_gettable(c:\my_trace.trc", default)because one file will be always be used..i some how need to get info of the file being used or capture the file sizes so that i can get the name of the files...and load into the table....something...on those lines...any lead would be greatly appreciated...ThanksTue, 28 Jul 2009 14:36:23 GMTchinn