Something strange ?I ran into today.
After inserting rows into a table and receiving no errors and xx row(s) inserted messages,
Selecting from the table yielded no rows. Select count(*) resulted in 0.
SP_SPACEUSED resulted in 0 row.
I ran dbcc dbreindex on the table and no change(inserts successfull but no results on select)
There were no triggers on the table but I did notice a large number of statistics.
Just about one for every column and the index.
I removed all statistics except the one for the index becaus i wouldnt allow me too.
I then ran SP_UPDATESTATS.
Table still was empty but now when I insert the rows are there when I select.
What truly caused this bizzare behavior and how can I be certain this doesnt happen especially in a production environment?
Has anyone experiened this before?