Whe I do the following

SELECT INDEXPROPERTY(OBJECT_ID('message_done'), 'pk_message_done', 'IsPageLockDisallowed')

I get the output as ZERO and when I do the following

SELECT INDEXPROPERTY(OBJECT_ID('message_done'), 'pk_message_done', 'IsRowLockDisallowed')

I again get the output ZERO.

Shouldn't it be ZERO in one case and ONE in other, as a table can either have ROW level locking or PAGE level locking.

Thanks.