Have two databases on same SQL Server instance.
If I run
EXEC sp_helprolemember I get different MemberSID values for dbo on each. (the 2nd half of the SID is different, the start is the same)
DbRole = db_owner, MemberName = dbo, MemberSID = 0x0105000000000005150000003D85B1B0F17DF0097CD12B
DbRole = db_owner, MemberName = dbo, MemberSID = 0x0105000000000005150000008641B613459B05E16185E7
(note 2nd half of SID mangled by removing last 10 chars in case its sensitive)
What does the second half of the SID signify - in this case (dbo being a 'legacy style sql server login')
Would this SID difference account for any permission differences between the two databases?