Thanks everyone & Sorry for such a long delay...

Cause found: It was improper set up of the SANS. We used the Microsoft's SQLIOStress utility to check the SANS sanity. Once...

Gentlemen,

   Thanks for all your posts and help. I am sorry for being sloppy and posting this reply after a very long delay.

   With regards to the issue that was...

Interesting!! Recovery model and backup has no bearing to each other. Or thats what I thought! Let alone SQL Server changing the option!

As everyone said, it should be 'From People' than 'From Poo'. If its 'From People' it will return 3 rows. But the query posted is wrong. Points back please!!

Thanks Frank. I can even convince myself by saying identities can get funny based on several factors. But a primary key col to allow duplicate is very very very strange.

mmm, Its very tricky. We have looked through the app and seems to be ok. There are many SPs running which use '@@Identity', 'Scopr_Identity' and 'Ident_Current' in different places....

Thanks Frank and congrats on your 3000th post.

The app is not inserting values to this identity column. Thats why the whole confusion is. The column is Primary Key and it...

Thanks for the replies. We donot have any 'ignore dup' keys set on any index. More over this is a PK.

If I run DBCC checkDB it gives error on allocation...

Thanks for the reply. We are not BCPing. Also the table is used by an ASP application and no manual insert is allowed. Identity_Insert is off for this table. We...

Thanks for the reply. This is on SQL2000. I have tried sp_repldone. No use.

Silly me. It was the package 'logging' properties. I had 'Write completion status to eventlog' option selected and looking all over the place. Sorry for wasting people's time. Thanks anyways.

Interesting.. This is more of a question than comment (I am not that good to comment). How about writing my own log reader? That would give me more control. Is...

Thanks very much. Very much appreciated.

Thanks very much. Is there any other way of finding the object with the page number? (ignoring SP_Lock)

Thanks