To create all of the user and membership tables in SQL Server 2010 there is a command line tool within the tools directory (use the link to the command prompt) that can be used. The command to get the tool to create the tables is:
ASPNET_RegSQL.exe -S (Server) -d (Database) -A m -E
-A m creates the membership tables and -E uses a trusted connection.
The command creates the Applications, Membership, SchemaVersions and Users tables for ASP.NET.
