Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0
This is the forum to discuss the Wrox book ASP.NET 2.0 Website Programming: Problem - Design - Solution by Marco Bellinaso; ISBN: 9780764584640
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 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 October 6th, 2006, 05:04 AM
Registered User
 
Join Date: Sep 2006
Location: UPPSALA, , Sweden.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to gerten
Default Get Error 1813 when attach db to SQL2005

Hi I read the following Readme.txt how to install TheBeerHouse project. And using SQL Server 2005.

When i try to attach as following i get error:

Code:
exec sp_attach_db @dbname = N'TheBeerHouse',
@Filename1= N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\TheBeerHouse.mdf',
@filename2=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\TheBeerHouse_Log.ldf'
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.
 
Old October 6th, 2006, 11:22 AM
Friend of Wrox
 
Join Date: Aug 2006
Location: , , .
Posts: 131
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to kherrerab Send a message via Yahoo to kherrerab
Default

create the db first.. then use the scripts to create everithing. the scripts are in the app_data folder.

 
Old May 27th, 2014, 05:10 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2014
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Resolve SQL error 1813 in simple steps

Go through this:- http://www.sqlrecoverysoftware.net/b...rror-1813.html




Similar Threads
Thread Thread Starter Forum Replies Last Post
Replication with SQL2005 seananderson Access 0 November 30th, 2007 05:32 AM
Add a 2'nd SQL2005 db ADH BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 1 August 25th, 2007 06:08 PM
Sql Express Error -An attempt to attach an auto-n virendar23 ASP.NET 2.0 Professional 1 December 19th, 2006 09:24 AM
SQL2005 to SQL2000 issue SoftMind BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 2 May 2nd, 2006 09:09 AM
Attach dB Failed ioates SQL Server 2000 5 June 30th, 2003 04:25 AM





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