I got this error when trying to use /c:ClearPartition
Msg 4972, Level 16, State 1, Line 1
ALTER TABLE SWITCH statement failed. Check constraints or partition function of source table 'Sony_PartitionTest.dbo.Article' allows values that are not allowed by check constraints or partition function on target table 'Sony_PartitionTest.dbo.myStagingTbl3'.
the error seem to be related to how the date format is interpreted by the Partitinon Manager tool.
00:00:00' AND [ProcessedDate]<N'01/07/2011
If I set the date format in sql management studio,
then perform the Switch manualy, it seems to work
SWITCH PARTITION 2
But it does not work using partition manager .
Is there away I can change the way partition manager sees the date? or run set datetformat dmy before the swittch is called ?