If you decide are a later point you wish to add the ASP.NET membership provider tables to a database or want to use them in a different database, here is  blog post that shows how to easily generate the script to build the tables and support features:

http://blog.krisvandermast.com/CreateMembershipTablesInAnotherDatabaseThanTheStandardAspnetdbmdf.aspx