Wrox Programmer Forums
|
BOOK: ASP.NET Website Programming Problem-Design-Solution
This is the forum to discuss the Wrox book ASP.NET Website Programming: Problem - Design - Solution, Visual Basic .NET Edition by Marco Bellinaso, Kevin Hoffman; ISBN: 9780764543869
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET Website Programming Problem-Design-Solution section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 7th, 2007, 01:53 PM
Registered User
 
Join Date: Jan 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default sp_attach_db @dbname=N'TheBeerHouse'

1. I am trying to run
sp_attach_db @dbname=N'TheBeerHouse' from Readme file

2. and I am getting this message:
----------------
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'TheBeerHouse'. CREATE DATABASE is aborted.
Msg 602, Level 21, State 50, Line 1
Could not find row in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
------------------
3. If I am creating TheBeerHouse database, I am getting this message:
-------
Msg 1801, Level 16, State 3, Line 1
Database 'TheBeerHouse' already exists.
-------
Could you, please, help me with this problem?


 
Old January 9th, 2007, 12:42 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What problem - it's already there? Are you using SQL Express, or full SQL? If you have SQL Express you don't have to attach it unless you want to use it from non-ASP.NET apps.

I'd run "DBCC CHECKTABLE" if I were you. This can fix possible damage.

Did you try to "use" TheBeerHouse and do some queries?

By the way, this is the forum for the first edition. There's a forum for the 2nd edition here:
http://p2p.wrox.com/forum.asp?FORUM_ID=261

Eric










Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.