>OK, I've done it. I've installed a new server (to replace an existing one) and didn't pay attention to the collation setting at the server level.
>
>
>I continued anyway (maybe my first mistake) and I restaured all the BD on that server (user db). I also had to move my 35 DTS packages one by one (I could not find a better way of doing it) and re-created my 50+ jobs....
>
>Since the collation is different from my other sql servers, I ran a small program to change the collation of every columns in the DB to be the same as my other server. But the server itself remains with a bad collation.
>
>This is still causing problem, joins are a pain in the but and I'm stuck with a equijoin that does not want to work.
>
>I'm thinking of using rebuildm.exe, but I'm afraid to loose my DTS and jobs again.
>
>How whould you handle this ?
>
>Thanks.

I do this via VFP, but not sure about DTS so backup all before you try

Here my way in VFP, I think it is easy to do it via SQL Query analizer:

IF SQLEXEC(sqlh,"SELECT DATABASEPROPERTYEX('YourDataBaseName', 'Collation')","cTte") > 0
   SELECT cTte
   IF UPPER(ALLTRIM(cTte.Exp)) # "CYRILLIC_GENERAL_CI_AS"
      cmd = "ALTER DATABASE YourDataBaseName COLLATE Cyrillic_General_CI_AS"
      SQLEXEC(sqlh, cmd)
   ENDIF
   USE IN cTte
ENDIF

of course I have SQLSTRINGCONNECT() and SQLDISCONECT()