sp_familylock

A partitionid column has been added to the output of the sp_familylock stored procedure.

The syntax is:
sp_familylock

Table lock and fine-grained lock values for partitionid are 0. partitionid is populated only for partition-level locks.

spid  locktype             table_id     partitionid     page   row…
----  ------------------   -----------  -------------   -----  ----
0     Ex_partition           576002052      576004423       0     0
0     Sh_partition_intent   1417053053     1417053053       0     0
Related concepts
View Partition Locks with sp_familylock