Posted by Peter Nurse on 10/20/93 11:43

Erland,

Third reply to a single post - is that a record? I've done a lot of
research while you've all been been sleeping in Europe!

I completely uninstalled & reinstalled SS 2005 (rather than upgrading
from SS 2000) and then attached my databases. Problem disappeared.
I'm sure the problem was to do with msdb which was
SQL_Latin1_General_CP1_CI_AS but now is Latin1_General_CI_AS.

My databases remain SQL_Latin1_General_CP1_CI_AS but it no longer seems
to be a problem.

Thanks very much for your assistance.

• Next in forum: SQL Server 2005: Migrate DTS to Where?
• Prev in forum: Re: How to fire a trigger without changing table data
• Thread view: Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties

[Reply to this message]