Hi,

Is there any way we can check which process led to the NOP command.

In my scenario this happened when there was no activity on the DB Box.

Thanks,

Tushar Chheda

Hi,

Well Chris, I do have a maintanence plan for the DB but I have not selected any option that would truncate a log. The plan is to check the db...

Thanks Ray

but my problem is i do not want to use dts, i want to generate using sql stored procedure or query analyzer.

Regards,

Tushar Chheda