HI.. I do not have a 'run as' window on my GENERAL tab. I've looked on the other 2 tabs, LOG FILES and SCHEDULES, but nothing there either.

Juanita

Thank you so much for the replies... I'm reading about them now.

Juanita

AH HA !!! that was it.. I had everything like you said, except I didn't put the % signs in front and back..

Thanks so much 

Juanita 

Thanks so much !!!

Juanita

Thanks so much for the answers !!!

Juanita

Good point !! Thanks !!

Okay, I got it.. so your tlog is kept under control by checkpoints issued by sql server.

Thanks everyone !

Juanita

HI. so then the tlog should not get to be this enourmous size?? Under the file properties for the tlog, should the option of AUTOMATICALLY grow file not be checked...

Thank you so much !!! These ideas are perfect !!!

Juanita 

HI.. What exaclty is a cursor? I've never worked with that before?

Juanita

HI. Thanks so much. That was it!

Juanita

David,

Thank you for the code. This is great !!.

Glauco,

Can you send that stored proc again? I tried to execute it and it says that doesn't exist.

THANKS SO MUCH !!! PERFECT !