Agreed, complaining is easy. But when you claim to be the largest sql community on earth, it looks silly not to live upto those standards.

It is not just QOD....

Reads like a story. We know we need to restore or re-snapshot when such a thing happens. What would have added value to this article is, "what originally caused the...

sorry, if i offended anyone. i am an average dba, and the first place i go to, when i am stuck is books online, next place is kb. if i'm...

why are you guys "repeating" the information from microsoft knowledgebase? this information is documented in the kb article: Q224071

instead write some more original articles!

--jamie

that is a pretty obvious error to debug, isn't it?

here is a simple example

create table test(i tinyint identity, j int)

insert test select id from master..sysobjects