I just wonder what is the usage of sys.sysrowsets in SQL Server? Microsoft said it
“Exists in every database. Contains a row for each partition
rowset for an index or a heap.” But what is a partition?
Also what is the meaning of idmajor and idminor for this
table? I try to find the object ID of a table(246486340)
and then execute the query:
Select * from sys.sysrowsets where idmajor
The results are two records:
rowsetid ownertype idmajor idminor numpart status fgidfs rcrows
246486340 1 1 6 0 2582
72057603612213248 1 246486340 6 1 2 0 2582
But I think there should only
be one record with that major id.