Import fail - SQL Server Forums

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)

Import fail

Author

Topic

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2002-03-06 : 03:17:23

Server1: NT4 EE SP6a and SQL 7.0 SP1
Server2: NT4 EE SP6a and SQL 2000 SP2

Operation: Import from SQL 7.0 SP1 to SQL 2K SP2

I have the following error:

Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 42000)
Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve collation conflict for equal to operation.
Step Error code: 800401BE
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:1131

Can anyone help?
TIA and Best Regards.
Franco

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2002-03-06 : 11:20:58

Fix it.
I had a different collation settings.
Franco

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources