Error "Collate" relaciones tablas

[fuentesn8]

Ok gracias,

Poes mira la sentencia que use para crear la tabla reservas es la siguiente.
CREATE TABLE [dbo].[tblReservas](
[numtiquet] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[numvuelo] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fechaviaje] [datetime] NOT NULL,
[clase de reserva] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[nombre] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[numtiquet] [email] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[status] [int] NOT NULL,
[reservadopor] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fechadereserva] [datetime] NOT NULL,
[confirmaciontiquet] [bit] NULL
) ON [PRIMARY]
GO


Y Para la otra tabla en question es la siguiente:

CREATE TABLE [dbo].[Detallesvuelos](
[numvuelo] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[origen] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[destino] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fechasalida] [datetime] NOT NULL,
[fechallegada] [datetime] NOT NULL,
[tipoavion [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[asientosexec] [int] NOT NULL,
[asientosbussines] [int] NOT NULL,
[tarifaexec] [int] NOT NULL,
[tarifabussines] [int] NOT NULL,
[fechasalida] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO