Home Forums SQL Server 7,2000 T-SQL sp_CompareDB "Cannot resolve collation conflict for equal to operation." RE: sp_CompareDB "Cannot resolve collation conflict for equal to operation."

  • March 23, 2004 at 7:55 am

    #500030

    ALTER DATABASE Userdb COLLATE  Latin1_General_CI_AS.

    Will change the user db's - You can't change the tempdb because it is a system db