How to create the default aspnet membership tables in SQL Server

One of the things that I keep having to look up is the command to create all of the default aspnet membership tables

All you need to do is to go into the .net framework directory (mine is C:\Windows\Microsoft.NET\Framework\v2.0.50727) and type aspnet_regsql and then follow the wizard

You can find out more information at http://msdn.microsoft.com/en-us/library/x28wfk74.aspx