Hi

I’m examining my tables, in particular the following tables:

aspnet_UsersinRoles = 0 rows
UserRoles = 21 rows
aspnet_Roles = 0 rows
Roles = 15 rows

I understand that there is a relationship (in theory, not actuality) between these tables in order to extend the number of columns and keep the ASP.NET membership provider clean.

1) Looking at the detail above would you say I might have a problem here, should there be rows in table aspnet_UsersinRoles and table aspnet_Roles (considering there is a "virtual" relationship with the other two tables?) Or is there nothing to worry about?

2) I’m also interested in how users relate to each other, for instance in table aspnet_users I might have a userID of 9a8de0de-688b-4f27-8c70-b3ebee339b6d yet in table users the userID might be 54.

Many thanks

Alex

p.s. I'm running 4.3.3 and SQL Server 2005