either you can do database snapshot

secondly,

you can do backup and restore that won't hurt your user current running DML operations.

Backup runs checkpoint and don't take any locks on database and...

Use update table statement.

why can I not get the log file drive space reallocated back down to a more reasonable amount?

There should be open transaction running for long which does not commit...

Configure E-mail Id's in Database mail.

Follow this link[/url]

then it should work properly or

use msdb.sp_send_dbmail

Check BOL for this

It all depends on your insert statement

like how many rows you are inserting or

any default value columns in tables or

...

Thanks,

I would prefer Change data capture very easy to use ad more information you get

This is all if you are in sql server 2008.

It works thanks, but can you explain why?

I did before changing directly in the field it shows you there it is changed but when you see in sp_configure it won't show you check under run_value...

select SERVERPROPERTY('productlevel')

gives service pack info in SSMS

So connect all through SSMS and find it for both database services and reporting.

Regards,

Pavan Srirangam

What is your recovery interval setting.

check dbcc opentran if there is any open transactions that truncating.

Check select * from sys.jobs.

regards,

Right click on the job and enable it or refresh it.

Regards,

Pavan Srirangam.

There should be no problem even if it is the default

If you want to change you can change

Directly in the field where is the default

and also you...

Did you check error log?

Check isolation for snapshot isolation level which stores data in tempdb while retrieving data so that actual table can be updated with out lock any row locks will be there