Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8
This is the forum to discuss the Wrox book Beginning ASP.NET 2.0 by Chris Hart, John Kauffman, David Sussman, Chris Ullman; ISBN: 9780764588501
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 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
  #1 (permalink)  
Old October 30th, 2007, 04:28 PM
Authorized User
 
Join Date: Jun 2006
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default cannot attach to databases with SQL Server Full

Hello,

I have a full version of VS Studio 2005 along with SQL Server 2005 installed on a Windows 2003 server. I downloaded the corrected Appendix B documentation but still cannot successfully attach to the wroxUnited.mdf file. First off, this directory does not exist on my computer: c:\Program files\Microsoft sql server\mssql.1\mssql\data, so I created my own 'data' directory copied the two .mdf files (wroxunited and aspnetdb). When I clicked attach >> Add >> chose wroxunited.mdf then click ok, I receive the following error:

Attach database failed for server 'myServer' Microsoft.sqlserver.smo

additional information:
An exception occurred while executing a transact-sql statement or batch. (microsoft.sqlserver.connectioninfo)

could not find fow in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes
Could Not Open new database 'G:\BEGASPNET2\FINALAPPLICATION\WROXUNITED\APP_DAT A\WROXUNITED.MDF' CREATE DATABASE is aborted. (Microsoft SQL Server Error: 602)



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create databases using SQL server 2005 jayraj_pune ASP.NET 2.0 Basics 2 March 6th, 2007 02:06 PM
Connection problems with Full Sql Server Lightwaver BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 13 February 12th, 2007 08:30 AM
attach database in SQL server express manag studio bruhnf SQL Server 2005 0 March 14th, 2006 08:37 AM
SQL Server - System log full Jane SQL Server 2000 3 December 23rd, 2004 10:10 PM
Browse for SQL databases on a given server RFickling C# 1 November 11th, 2004 02:33 PM





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