Quote Originally Posted by liakat
this proc drop part based on value
No it doesn't. It drops partition based on partition_name.