Cars break (or don't brake, thank you Toyota, Honda, Ford), planes break (Boeing, Airbus), my bones have been broken (Mom).

It all comes down to using the best practices to try...

Hi Gail,

I suspect he\she was commenting on the followup comments regarding corruption, dbcc, video links etc..

Thanks to everyone for posting the links and other comments, it turned a bad article...

This also goes back to a point made a few months back of being careful on what you deploy based on an article you've read on the web. ...

Thanks for all the info. I think we can kill this thread off here.

I'll pass this along to the group.

Thanks for the quick reply, that's what we are thinking over here. I check with the hosted team to see what their thinking is behind their plan.

Dave

This is a great reminder about not only understanding what you are about to do with the advice, but learning from it as well.

Working in a support environment,...

Thank you both for this thread. Had a customer database

and they started getting this error a month ago. 8 million rows in the table and BCP and...

So, were you able to update the path in msdb.dbo.syssubsystems ?

That was my thought when I came across this but didn't pursue it further after copying over the folder.

Hi Yul,

While I don't have an answer for your question, I thinking that maybe a post SP2 fix brought the issue to the surface.

I wanted to follow up on my...

Sorry, didn't see the additional reply pages. I'll try recompiling the SP's and see where that takes me.

I'll gladly move this along.

Running a dbcc checkcatalog after a dbcc checkdb gives me the following error:

Msg 3853, Level 16, State 1, Line 1

Attribute (parent_object_id=1858417990) of row

(object_id=1874418047) in sys.objects...

Hi,

Ran into the same issue. Reinstalled .Net 2.0

but the issue persisted.

Came across this article

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=525809&SiteID=1

which pointed me to

http://support.microsoft.com/?kbid=903205

While the version in the KB didn't...

Nice script Tom, we've used it a couple of times already!

Thanks

Dave

Try running these two statements at the same time:

With Dups as

(

select *, row_number() over (partition by Product_Code order by Product_Code) as RowNum from #prod

)

Delete from Dups where rownum >...