history of Process info

i think i might a have a slight clue about this but need help...
in SQL Server Enterprise Manager -- Management -- Current Activity --
Process Info i can see the current info for SPIDs and users and all sorts of
great info.
How can i view that same info from yesterday at a specific time?
thanks a million.
You could use a log reader tool of which there are many to choose eg
Lumigent's LogExplorer.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||"Paul Ibison" wrote:

> You could use a log reader tool of which there are many to choose eg
> Lumigent's LogExplorer.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
> Lumgent wants $995
|||Ok there's a new low-cost ($195) alternative from Redgate:
http://www.red-gate.com/products/SQL_Log_Rescue/index.htm.
BTW I'm assuming that you actually have the log as a backup, or have been
using full recovery mode. if you've used simple then this strategy won't
work for the particular transaction you're looking for.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .