Yes it was orginally written for SQL2000 and now running in 2005. You are right, I can modify this using TRY/CATCH and will be much happier if I do...

Thanks - good advice all around! I appreciate the suggestions and I will be braver at the beginning of the week rather than the end. Don't need...

Thanks for coming back to this one Phil. I'm glad the problem went away for you. For me the challenge of developing has moved from writing good code ...

Did anybody ever figure this out? There are 3 of us that work on SQL and SSIS. One of us can open "older" SSIS (DTSX) files and the...

Thank you - good reference info.

Thanks for the responses. I will look into using trace. I was hoping to find something built in but you can't win them all!

later

Thanks for the response - That query provides lots of information but nothing to do with users and access times. Maybe I just don't know how to use it?

These may have been killed manually by my predecessor since these jobs appear to be "hung". Are we to believe that these processes are rolling back an action since...