You are correct, sir.

Thank you very much.

Burt

You were absolutely right. The jobhistory table showed me everything I needed to see.

Thanks again.

Burt

I found the table, but it just sez the same thing - the job failed in step X.

I need to see the "feedback" from the sp execution - so I...

because I have no idea what that is?

plz enlighten me, if u have the time.

Thanks,

burt

Hi,

I think I figured out what is happening.

The problem arises when I try to run the above script/job for the second time.

There seems to be the need to sp_dropdevice in...

Hi,

approximately 1K lines of sql - maybe 45 "paragraphs".

The "script" builds many tables for subsequent use in an OLAP thing.

I need to initiate it "off hours" - like at 3:00am.

I...