Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Sort order problem in moiving a database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-22 : 22:49:10
Martin writes "Hi.

I have a problem which I hoped someone here could answer.
When I try to "move" a database from one SQL server to my SQL-server, it complains about the sort order. I have 52 and the database i try to "move" has sort order 59.
When I say "move" I mean that Ive tried to detach & attach the db (sp_detach_db, sp_attach_db & sp_attach_single_file_db T-SQL commands) and also I´ve tried to restore from a .dmp file.

My SQL is:
MS SQL 7.0 no service pack.

The other SQL server is:
MS SQL 7.0 (dont know the service pack)


Thanks alot.

-Martin"
   

- Advertisement -