p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 (http://p2p.wrox.com/forumdisplay.php?f=228)
-   -   cannot attach to databases with SQL Server Full (http://p2p.wrox.com/showthread.php?t=63363)

dhx10000 October 30th, 2007 04:28 PM

cannot attach to databases with SQL Server Full

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)

All times are GMT -4. The time now is 12:22 PM.

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