Thanks Jeff,

I can run the original query succesfully from my local instance. I have cut it down as suggested and i can still run it on my local instance. It's...

Thanks,

I can confirm that I am running sp_configure 'Show Advanced Options', 1; first before I do the reconfigure.

I can get the query to work from my local machine now but...

Thanks, yes it's one of my production databases, it's not doing any harm like you said other than the annoyance of my maintenance always failing on checkdb.

I will look into...

Thanks Gail, I was afraid that those would be my only options. Yes that is the only errors I get back from checkdb.

Thanks for the help Jan, I have a few things now that I wam going to try.

thanks, Yes generateinserts creates inserts with INSERT table(Values), you can omit the column names but it creates the inserts per table with GO after every table.

It times out when it...

Thanks,

I have been using the timeout option with osql but I am having instances where it is still running 48 hours after I set it in motion whereby I guess...