So if we were running a 24/7 operation then you would recommend that we go with Enterprise edition?  This would stink since this would be the only reason for us...

One thing I have seen is when the job is associated with a Maintenance procedure it will error if you try to delete the job before deleting the Maintenance Plan. ...

Ok...here is what the log says. 

Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.2153

Report was generated on "ibis".

Maintenance Plan: Weekly-Rebuild All User Indexes

Duration: 00:00:11

Status: Warning: One or more tasks failed..

Details:

Rebuild Index...

Thank you.  How do I write the job output file to a file? I am running the job directly from the Studio interface.

Its actually SQL 2005 Developer edition

You guys are great! Thank you.

Thank you!  I looked up some articles on the site and found a few things.  I guess without some kind of baseline its hard to tell. 

Really?  So when I post a message and I use the insert picture button and it posts the picture I am the only one who can see it in the...

I'm very glad I've found this site back in March.  I've recently been given the task of learning SQL2005 and all that goes with it as far as administering the...

Thats just it...it didnt reference the trigger at all...in the error message or in the log.  It definately makes sense now that I know what caused it.  You can see...

SOrry.....yes Im certain it would have solved the problem....unfortunately I didnt see the post till after I did the restore....although I ran the same scripts and created the same problem...

NICE!  I didnt even think of that!  Wish I had checked the forum before I did the following....although my resolution worked I would have much rather just dropped the trigger. ...

So I'm stuck with this table in my database that I cant delete?  Do I need to resort to restoring it from backup?

I would have thought the same thing....I guess Im just having trouble understanding this error then....when I try to delete the table:

Sorry...are you refering to the bad object? The table was created for sure....but the bad object being refered too i cant find....so if it didnt get created whats generating the...