Creating Membership Tables, SPROCs, Views in Attached DB
- by azamsharp
I have AdventureWorks database mdf file in my VS 2010 project. Is there anyway I can create Membership tables inside my AdventureWorks database. I know I can detach the database attach in SQL SERVER 2008. Create the tables and then detach. But I don't have SQL SERVER 2008 and I want to see if this can be done using command line tool.
I tried this but no use:
aspnet_regsql.exe -d AdventureWorks.mdf -A mr -E -S .\SQLEXPRESS
Update:
If I right click and see the properties of the AdventureWorks.mdf database then it shows the name as
"C4BE6C8DA139A060D14925377A7E63D0_64A_10\ADVENTUREWORKSWEBFORMS\ADVENTUREWORKSWEBFORMS\ADVENTUREWORKS\APP_DATA\ADVENTUREWORKS.MDF"
This is interesting!