How can we help you today? How can we help you today?

aspnet_Membership - no rows generated

I am trying to generate membership data for an asp.net application. The site uses the standard aspnet_users and aspnet_membership tables that both have a primary key = userID that is a uniqueidentifier.

When I run SQL Data Generator, the records in the aspnet_users table are generated but no data is generated for the aspnet_membership table. The tool reports: "Generation stopped: The generator for column UserId could not generate any more values. Rows inserted: 0". The UserId field is set to use the Foreign Key Generator.

This is my first use of Data Generator so I am sure I am just missing something.

Any thoughts?

Thanks
ROB
rbanning
0

Comments

1 comment

Sort by
  • rbanning
    Looks like the problem was a table that was referencing the data in the aspnet_membership table. Once the relationship was removed, the data generator worked as intended.

    Cheers,
    ROB
    rbanning
    0

Add comment

Please sign in to leave a comment.