InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 09:51:01 GMT20http://www.sqlservercentral.com/Forums/Topic1410865-1550-1.aspxThanks all.Yes that's what I found too, I am using 2008, and it prompts if I want to open rollover files. And I see a Find button that is not very helpful to search.I think I will use T_SQL then.ThanksThu, 24 Jan 2013 09:32:25 GMTsqlfriendshttp://www.sqlservercentral.com/Forums/Topic1410865-1550-1.aspxIn addition to what Gail said, here is a simple script to Read from the default trace[code="sql"]DECLARE @path NVARCHAR(260);SELECT @path = REVERSE(SUBSTRING(REVERSE([path]), CHARINDEX('\', REVERSE([path])), 260)) + N'log.trc' FROM sys.traces WHERE is_default = 1; SELECT * FROM ::fn_trace_gettable(@path,DEFAULT)[/code]Thu, 24 Jan 2013 00:09:43 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1410865-1550-1.aspxMuch easier to use fn_trace_gettable and then filter within SQL. The profiler GUI's a pain to filter, sort and search in.Wed, 23 Jan 2013 23:36:32 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1410865-1550-1.aspxIn SQL 2005 & 2008, Under SQL Profiler Options there should be a radio button under "File Rollover Options" to say "Prompt before loading rollover files". And yes, there is also a way to filter and search through the trace file itself - click on the "find" icon, or press [b]Ctrl-F[/b]Wed, 23 Jan 2013 19:40:50 GMTMyDoggieJessiehttp://www.sqlservercentral.com/Forums/Topic1410865-1550-1.aspxWhat version of Profiler are you using? I get a popup asking me if I want to open the next Rollover file.I'm using Profiler from SQL 2008 R2.LeoWed, 23 Jan 2013 19:34:44 GMTLeo.Millerhttp://www.sqlservercentral.com/Forums/Topic1410865-1550-1.aspxIf I open the default trace log in sql server profiler to view.It opens all the rollover files in one window.Is there a way that I can filter out the records by some criteria?I don't see an option, I can see a find... option, but it is not very helpful.Wed, 23 Jan 2013 18:42:47 GMTsqlfriends