Here's the error..works fine if a file is there..

Corp 1984-2005. All rights reserved. Started: 12:30:59 PM Error: 2012-09-13 12:31:00.10 Code: 0x00000000...

I'll check them both out.

Thanks Grant.

yeah it was a rights thing...

thanks for your help..

Yep that was it!

Thanks guys ...really really appreciated!

I know now that my problem is in this part of the statement:

SELECT DATEDIFF(YEAR, EecDateOfOriginalHire, getdate()) from empcomp EC WHERE EC.EecEEID = eepeeid

awesome thanks guys for all the help

thanks for answering/helping...

recovery model is set to full

It's set to grow by 10 percent.

got it thanks!!

Thanks Jack..

My guess is another job(s) running...

We are checking now...but we wondered if it could be anything else.

prefect thanks!

I figured it out..

thanks guys..

Thanks Lowell!

Your stuff is always so good. Wish I had read your reply before I started on what I wrote:

;with cte as (SELECT

E.eecCoID AS 'Rec ID',

E.EecEEID AS 'Emp...

You are right!

That did the trick!

Thanks soooo much for all your help Andy!

Nope!

<bangs head against wall>

Sure doesn't (still shows years and years of terminations) and I can't figure out why if I run just this:

SELECT (eecDateOfTermination)

FROM EMPCOMP

WHERE

eecDateOfTermination IS...