Are you speaking about http://msdn.microsoft.com/en-us/library/ms191160.aspx ?
If yes, i am not sure to have understood the 2nd note
"During an ALTER TABLE…SWITCH operation, a schema-modify lock is acquired on both the source and target tables to make sure that no other connections reference the tables during the change"
and the Caution note in the Table and indexes requirements part
"Partition switching can introduce duplicate values in IDENTITY columns of the target table, and gaps in the values of IDENTITY columns in the source table. Use DBCC CHECKIDENT to check the identity values of your tables and correct the values if you want"
I think that , with mypoor english, i have missed something especially for the IDENTITY columns ( why these gaps and duplicate values ? )
commented on Aug 18 2011 1:43PM