Posted by Ryan on 12/19/05 19:33

I've looked further into this and tried re-installing SQL2000. Nothing
was any different, and nor was there any option to change the
collation. Now from what I understand, the SQL_ collation was the
default in SQL7 and this then changed in SQL2000. Our server shows SQL_
so I assume it would have been upgraded to SQL2000 at some point
(although I'm told otherwise). We don't have a copy of SQL 7 (which
backs up the none upgrading).

I was thinking of installing 7, then upgrading as this 'should' do the
trick. However, without a copy of SQL7 I'm stuffed. I can't change the
server, so can't figure what the next step would be. All I'm interested
in is matching the server. If I can't do that, then I can't work.

Even if I get a new server, I expect this will give me the same
problems.

I tried using RebuildM.exe and this doesn't give me the option. Is
there any way of adding this ?

Any further ideas ?

Thanks


Ryan

• Next in forum: Re: Can't connect to Oracle Dbase with SQL Server 2005 Express
• Prev in forum: RESTORE an Old Filegroup into an UpTodate Database
• Thread view: Re: Cannot resolve collation conflict for equal to operation.

[Reply to this message]