Hi,
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 = 246486340
The results are two records:
rowsetid ownertype idmajor idminor numpart status fgidfs rcrows
72057603504865280 1 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.
Thanks