Example:

Script 1

CREATE TABLE [dbo].[test] (

 [field1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [field2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [field3] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [field4] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS...

Just a thought.  If you are using two different Databases.  Script out the two tables and make sure the schema is identical. I had a problem like this and that...