Hello guys,

Actually i was thinking is there any way to query the LDF ( sqlserver transaction log file) to get the operations performed during that time span?

Hope we can do it!

Regards
Salim



************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Get LogExplorer from www.lumigent.com , it's the only way AFAIK.

--
Jacco Schalkwijk
SQL Server MVP


"Salim" <salim_belim (AT) hargreaveslansdown (DOT) co.uk> wrote

Hi,

You can use this undocumented command:

DBCC log ( {dbid|dbname } [, { -1 | 0 | 1 | 2 | 3 | 4}] )

For example:

DBCC log ('pubs', 2)

I'm sure that you can find more information about this if you search on
google, i don't have the information about what each number means right now.

--
Regards,
Kristofer Gafvert - IIS MVP
http://www.ilopia.com - FAQ & Tutorials for Windows Server 2003, and SQL
Server 2000
Reply to newsgroup only. Remove NEWS if you must reply by email, but please
do not.

Problems with spam and viruses? See
http://www.ilopia.com/security/newsposting.aspx


"Salim" <salim_belim (AT) hargreaveslansdown (DOT) co.uk> wrote