Home Forums SQL Server 2008 SQL Server 2008 - General Not able to find historical data using SQL Server Profiler in SQL Server 2008 RE: Not able to find historical data using SQL Server Profiler in SQL Server 2008

  • To capture activity that happened yesterday, today, please look up DBCC TIMEWARP. Be certain to study the clarification on the 13th parameter:

    http://www.sqlservercentral.com/Forums/FindPost866665.aspx

    Alternately, generate a trace to capture only what you need and then ask the user to try again while you're running it.

    http://technet.microsoft.com/en-us/library/ms175047.aspx