Creating Membership Tables, SPROCs, Views in Attached DB

Posted by azamsharp on Stack Overflow See other posts from Stack Overflow or by azamsharp
Published on 2010-04-19T16:36:18Z Indexed on 2010/04/19 21:23 UTC
Read the original article Hit count: 361

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!

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about asp.net-membership