Detach & Attach Database

I've just created ASPNETDB database with ASP.NET Security. Now, I want to send this db to orther computer.First, I detached this db, then when I used attach database in that computer, there is an error :

Error 602: Could not find row in sysindexes for database ID 8, object ID 1, indext ID 1. RUN DBCC CHECKTABLE on sysindexes.

Please help me .Thank.

I guess you're trying to attach a database from SQL2005/Express to a SQL2000 instance. Since most system objects have been changed in SQL2005, you can't use a SQL2005 database in SQL2000. What you can do is to transfer database objects/data/schema from SQL2005 to SQL2000.

|||How I do ? Could you guide me step by step ! Thank.|||You can open VS2005->new an Integration Service Project->add a Transfer SQL Server Objects Task

Desktop Server

1. Today I've installed webmatrix andMSDE200Aand followed this instruction

"Select 'SQL2kdesksp3.exe' and save it to your computer.

Double-click on theSQL2kdesksp3.exe you downloaded.

Once you have run the self extracting exe (SQL2kdesksp3.exe), go to a command prompt.

Start > Run > cmd

Navigate to the directory you expanded the self extracting exe to and change to the MSDE subdirectory.

The default is C:\sql2ksp3

Type Setup SAPWD=(Some password) SecurityMode=SQL

Example:
c:\sql2ksp3> Setup SAPWD=password SecurityMode=SQL

After that gets done running, MSDE is installed.

Start services

To get the SQL Server running and the SQL Agent we need start the services.

right click My Computer > manage > services

Double click the following and set to Automatic.

MSSQLSERVER
SQLSERVERAGENT

Make sure both are on automatic."

then I restarted my comp. I've tried to connect to database but it did not work.

I need the reply ASAP!!!!

2.What are the different among MSDE200A.exe, sql2ksp3.exe, and sql2kdesksp3.exe ?

Fahrisal:

then I restarted my comp. I've tried to connect to database but it did not work.

Please explain "did not work".

Fahrisal:

What are the different among MSDE200A.exe, sql2ksp3.exe, and sql2kdesksp3.exe ?

FromMicrosoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A andMicrosoft SQL Server 2000 Service Pack 3a I have learned:

MSDE2000A.exe is the desktop engine for SQL Server (MSDE) and includes the Service Pack 3a patch - this is all you need