I downloaded and installed the personal web site. However, I can't attach to the database because it was apparently created with someone with a user name of "jking". So, I get an error message from SQL Server whenever I try to attach to the Personal.MDF
So, I decided to simply create a new database inside Object Explorer. But, I need all the table definitions and stored procedures from the personal web site so I can move forward.
Has no one else had problems using this database?
Dexter
Dexter
HurdlerWorld@att.net
"Life isn't fair, sometimes the pretty girl doesn't get kissed..."
thanks but that's not it. I am unable to attach to the original .MDF file from the Personal web site. So, I am recreating the database. Your stored procedure assumes that I have access to the database already and I don't.
I think this might require the intervention of the originally developers of the starter kit?
Dexter
HurdlerWorld@att.net
"Life isn't fair, sometimes the pretty girl doesn't get kissed..."
>Never mind....the scripts are actually part of the project itself. You just have to know where to look.
Please mark the post as answered now that you have found out the answer.
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
dexterm
Member
541 Points
148 Posts
Is there a script available to create the stored procedures and tables for the Personal Web site ...
Oct 18, 2008 04:13 AM|LINK
I downloaded and installed the personal web site. However, I can't attach to the database because it was apparently created with someone with a user name of "jking". So, I get an error message from SQL Server whenever I try to attach to the Personal.MDF
So, I decided to simply create a new database inside Object Explorer. But, I need all the table definitions and stored procedures from the personal web site so I can move forward.
Has no one else had problems using this database?
Dexter
HurdlerWorld@att.net
"Life isn't fair, sometimes the pretty girl doesn't get kissed..."
Ashvin Padhi...
Member
411 Points
102 Posts
Re: Is there a script available to create the stored procedures and tables for the Personal Web s...
Oct 18, 2008 04:27 AM|LINK
http://ashvinpadhiyar.blogspot.com/2008/04/stored-procedure-to-generate-insert.html
Asp.Net Developer
Vadodara - Gujarat
http://ashvinpadhiyar.blogspot.com/
Please remember to click “Mark as Answer” on the post that helps you. This can be beneficial to other community members reading the thread.
dexterm
Member
541 Points
148 Posts
Re: Is there a script available to create the stored procedures and tables for the Personal Web s...
Oct 18, 2008 06:43 AM|LINK
thanks but that's not it. I am unable to attach to the original .MDF file from the Personal web site. So, I am recreating the database. Your stored procedure assumes that I have access to the database already and I don't.
I think this might require the intervention of the originally developers of the starter kit?
HurdlerWorld@att.net
"Life isn't fair, sometimes the pretty girl doesn't get kissed..."
dexterm
Member
541 Points
148 Posts
Re: Is there a script available to create the stored procedures and tables for the Personal Web s...
Oct 18, 2008 03:19 PM|LINK
Never mind....the scripts are actually part of the project itself. You just have to know where to look.
thanks
HurdlerWorld@att.net
"Life isn't fair, sometimes the pretty girl doesn't get kissed..."
TATWORTH
All-Star
72415 Points
14017 Posts
MVP
Re: Is there a script available to create the stored procedures and tables for the Personal Web s...
Oct 20, 2008 11:08 AM|LINK
>Never mind....the scripts are actually part of the project itself. You just have to know where to look.
Please mark the post as answered now that you have found out the answer.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239