Finally, i've found a way to copy the database to the new server.

Since i was not able to find the offending object sysnsobjs, i've try to import my data by...

this is the script generated by the Mngnt Studio

----

USE [master]

GO

CREATE DATABASE [ssjb2] ON

( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ssjb2.mdf' ),

( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ssjb2_log.ldf' )

FOR ATTACH

GO

-----

For the Detach/Attach process, i don't use any code, just the Management Studio of SS2088.

So this is what i'm getting when i'm trying to attach the database file to SS2008

--------------------

TITLE:...

I have upgrade to SP4 but the problem persist.

I've try the detach and attach method but i'm getting an other error with that. Even if i'm using a unique...

The production DB is still at the SP 3 on SS2000. Maybe that's the problem. I'm upgrading it an i will retry.

And i'm getting thoses messages:

Processed 41240 pages for database 'ssjb', file 'master' on file 1.

Processed 1 pages for database 'ssjb', file 'mastlog' on file 1.

Converting database 'ssjb' from version 539...

For the backup, i'm using the command:

backup database ssjb to disk = 'c:ssjbbackup.bak'

And for the restore, this one:

restore database [ssjb] from disk =...

Woops,

I have now this error while restoring.

There is already an object named 'sysnsobjs' in the database.

Msg 3167, Level 16, State 1, Line 1

Maybe it's the way i'm backing up the...

Ok, the backup restore procedure worked fine.... I've forgot to check the replace Option the first time i've used it.

So much time lost by a so tiny detail.

Thank's

This is what i've try first, to make a backup copy of the SQL 2000 database and to try to restore it on the SQL 2008 but SQL 2008 didn't...