Thank you so much everyone.. I will look into this immediately.

Thanks again for all your answers, I appreciate the quick turnaround..

I don't think we have activated that policy. And it did not specify if it was the LDF or MDF.

So turn off Auto-Growth on LDF? What would you set it...

Any suggestion on good books or site to learn how to create good index?

It says 500KB.. what is the recommended size?

No problem, I cannot post my exact code for legal purposes but I will draft up an example for all the others.

Technically, the link that you've provided suggested using localVariables...

Thanks guys, I've implemented the fix and will be pushing it out tonight... hopefully it will resolve this issue.

I appreciate the quick feedback!