Can you check whether the SQL Agent startup account has necessary privilages ?

Regards

Fred

If the users can be stopped for 10 minutes, One simple solution is, detatch db and attach it back with only the .mdf file. .ldf will be created with default...

I have tried this way

create table xxx ( LEDef_Cd varchar(20))

insert into xxx values ('DB356')

insert into xxx values ('40ILTC0007')

insert into xxx values ('HW442')

insert into xxx values ('51NWAC000020')

insert into xxx values...

Hi

I think the time taken will vary because if the pages are loded in to the memory(Cache) it takes less time. In this case, when you run first time...