Photo Albums and Sever Error

Topics: Help
Apr 5, 2007 at 5:42 PM
Edited Apr 5, 2007 at 5:52 PM
I love this new release, but I have two question:

A) How do I delete a photo album?

B) Everytime I try to publish the SQL scripts I get the error that it cannot read the foreign key constraint.
I get this error:
Could not drop object 'dbo.aspnet_Roles' because it is referenced by a FOREIGN KEY constraint.

Any help for either of these would be great.

Thanks again,

Apr 5, 2007 at 8:57 PM
We haven't put in A... I think this shouldn't be too dificult to do.

For #2, are you using SQL 2000 or 2005?
Apr 6, 2007 at 3:37 AM
I am using SQL 2000.

Apr 6, 2007 at 10:43 AM
Do you know how to generate 2000 scripts. The tool I use (Publish to Provider) really doesn't do the trick and I have no way of testing it. Try plugging in the 2005 script.
Apr 6, 2007 at 3:24 PM
I am fairly new to VB and SQL. I don't know how to generate scripts. I gave the SQL 2005 scripts a try and I got this error: Invalid object name 'sys.foreign_keys'.

Any other ideas?
Apr 6, 2007 at 7:31 PM
I was wondering which database tables could manually be restored to zero records without breaking anything? In particular, I could like to delete all records in Albums, BlogComments, BlogPosts, Links, PollQuestions, PollAnswers, PollReactions, PollVotes and maybe a couple more if it doesn't cause a problem.

Apr 6, 2007 at 8:10 PM
That reminds me, I need to delete the poll stuff in the database. SQL 2000 might not allow photo objects... not sure. I always recommend a hoster with SQL 2005.