GilaMonster (12/21/2012)
What does the error message say you are missing?
what i can get from error is testtable_archive data is "falling out of range" from partition 1 but actually this table contains data range 31 to 40 (basicaly less then 500) ? then y its failing or i am overlooking something here ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)