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.

If I set the date format in sql management studio, then perform the Switch manualy, it seems to work

SET

 DATEFORMAT dmy

;

ALTER

TABLE dbo.Article SWITCH PARTITION 2 TO dbo.ArticleStage

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 ?

thanks alot

Yasir

What happens if you specify the desired dates in MYD format when you invoke the command?

-- Stuart

thanks for your reply, sorry I should have checked that you can pass in the data as a parameter

/PartitionRangeValue:<string> /v Value string to input to partition function to specify partition number

great tool by the way.

I was testing using one of the examples in the readme file using a hardcoded partitionId=2 (which is the partition I am interested)

ManagePartition/C:CreateStagingFull /d:sample /s:dbo /t:Address /p:2 /A:myStagingTbl

Fixed in version 3.0