Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
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.
  #2 (permalink)  
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.

  #3 (permalink)  
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
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Replication with SQL2005 seananderson Access 0 November 30th, 2007 04: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 08: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



All times are GMT -4. The time now is 02:40 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.