jvkondapalli (2/19/2013)
Correct me if I am wrong here.. looks like you are trying to archive data.How big is the data size in the table?
If the data size is significantly big, why don't you use partitioning? I see in your code, you are going against date to move data. You can use that Date Column as a partitioning column and deal with the data movement once a month/quateryly(depending on your requirement and/or archival strategy).
This way you can avoid Isolation levels from the picture. I am not against isolation levels but, I would avoid them as much as I can in my system unless until necessary.
Thanks
Jagan K
I think the question was more focused on explaining what she is seeing, rather than discussing other solutions (further emphasised by Gails response to my suggestion for an alternative solution :)). Also, partitioning is only available on Enterprise editions, this may not be available.
Jamie