Thanks.

Can you let me know what was done to troubleshoot the issue you faced in your last company?

We have now decided to find SQL traces thro profiler by knowing...

Could you please explain me how to do this (Analysis SQl traces)?

Yes. Both are simple.

And there are no active transactions when i executed DBCC OPENTRAN

SELECT log_reuse_wait_desc from sys.databases WHERE name='your2008db'

The above command shows NOTHING for all databases

Hi Paul,

Can i have your e-mail ID?

But this is not the case in SQL 2005 server.

Our application database's transaction logs grow more than what the actual data is imported.

Is it possible to see what occupies our transaction logs (all committed, uncommiteed, broken) through queries or...

Hi Dave,

Thanks for you prompt reply. Yes we do backup regularly and database recovery model is set to Simple.

Small mistake, it is configuration tools and not mgmt tools.