Wednesday, August 22, 2012

Index was outside the bounds of the array

An error occurred while executing batch. Error message is: Index was outside the bounds of the array.
Today i come up with the above error on development box. A table is tiny and only 89 thousands rows. I found the fowllowing two links from microsoft site.
http://social.msdn.microsoft.com/Forums/en/sqlxml/thread/d30194ae-9f6a-46ab-b054-6dc2ed9195c2
http://support.microsoft.com/kb/2459027
I am running SQL Server version Microsoft SQL Server 2008 R2 (SP1) - 10.50.2789.0 (X64)

I try to reproduce the same from created test database on the same error but it did not show up the same erro.

Resolution: Create a replica table of issue table and export the data that is works fine.

No comments: