Collation Issue

A month ago we upgraded from SQL 2000 to SQL 2005 and from NAV 4.01 to NAV 4.03 Update 6.

Since then, several of our users noticed that when they pull up the item list, the items aren't in the right order that they are used to. We identified that there was a collation issue that caused this and to restore our db.

We restored our db this weekend thinking the collation issue would be fixed but it is still there.

Here is a copy of the table definition (correct me if this is the incorrect term) of our db with the collation issue:

CREATE TABLE [dbo].[Live db$Item](
[timestamp] [timestamp] NOT NULL,
[No_] [varchar](20) COLLATE Latin1_General_CS_AS NOT NULL,
[No_ 2] [varchar](20) COLLATE Latin1_General_CS_AS NOT NULL,
[Description] [varchar](30) COLLATE Latin1_General_CS_AS NOT NULL,
[Search Description] [varchar](30) COLLATE Latin1_General_CS_AS NOT NULL,
[Description 2] [varchar](30) COLLATE Latin1_General_CS_AS NOT NULL,

Here is a copy of the table definition without the collation issue:

CREATE TABLE [dbo].[TEST db 11-15-07$Item](
[timestamp] [timestamp] NOT NULL,
[No_] [varchar](20) NOT NULL,
[No_ 2] [varchar](20) NOT NULL,
[Description] [varchar](30) NOT NULL,
[Search Description] [varchar](30) NOT NULL,
[Description 2] [varchar](30) NOT NULL,


Any idea's on how to fix this or what could have caused it?

Thanks