I have a site that uses sqlMembershipProvider and I get the error "invalid cast exception."  The tables and stored procedures were originally created using regsql.exe.  I read that the solution is to re-create the membership tables.  I'm looking for a good way to do this without damaging the rest of my site.  Can I just rerun regsql.exe on the data store?

I was able to re-create the membership tables using aspnet_regsql.exe -R followed by aspnet_regsql.exe -A.  Had to clear the membership, users-in-roles aspnet_users and roles tables