/****** Object: Table [dbo].[HR_COMPANY_HEADER] Script Date: 01/22/2011 12:59:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HR_COMPANY_HEADER](
[COMPANY_ID] [int] IDENTITY(1,1) NOT NULL,
[TRADE_NAME] [varchar](50) NULL,
[COMMERCIAL_ACTIVITY] [varchar](50) NULL,
[GENERATE_RESERVATION_DOCUMENT] [char](1) NULL,
[LICENSE_NUMBER] [varchar](15) NULL,
[LICENSE_ISSUED_DATE] [datetime] NULL,
[LICENSE_EXPIRY_DATE] [datetime] NULL,
[VERIFIER_ID] [int] NULL,
[INFO_1] [varchar](50) NULL,
[INFO_2] [varchar](50) NULL,
[INFO_3] [varchar](50) NULL,
[INFO_4] [varchar](50) NULL,
[INFO_5] [varchar](50) NULL,
CONSTRAINT [PK_HR_COMPANY_HEADER] PRIMARY KEY CLUSTERED
(
[COMPANY_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
----------------------------------------
/****** Object: Table [dbo].[HR_COMPANY_OWNER] Script Date: 01/22/2011 13:05:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HR_COMPANY_OWNER](
[COMPANY_OWNER_ID] [int] IDENTITY(1,1) NOT NULL,
[COMPANY_ID] [int] NULL,
[PARTNER_STATUS] [int] NULL,
[OWNER_TYPE] [varchar](50) NULL,
[OWNER_ID] [int] NOT NULL,
[INFO_1] [varchar](50) NULL,
[INFO_2] [varchar](50) NULL,
[INFO_3] [varchar](50) NULL,
[INFO_4] [varchar](50) NULL,
[INFO_5] [varchar](50) NULL,
CONSTRAINT [PK_HR_COMPANY_OWNER] PRIMARY KEY CLUSTERED
(
[COMPANY_OWNER_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[HR_COMPANY_OWNER] WITH CHECK ADD CONSTRAINT [FK_HR_COMPANY_OWNER_HR_COMPANY_HEADER] FOREIGN KEY([COMPANY_ID])
REFERENCES [dbo].[HR_COMPANY_HEADER] ([COMPANY_ID])
GO
ALTER TABLE [dbo].[HR_COMPANY_OWNER] CHECK CONSTRAINT [FK_HR_COMPANY_OWNER_HR_COMPANY_HEADER]
------------------------------------------------------------------------------
/****** Object: Table [dbo].[HR_PERSONS] Script Date: 01/22/2011 13:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HR_PERSONS](
[FIRST_NAME] [varchar](150) NOT NULL,
[LAST_NAME] [varchar](150) NOT NULL,
[TITLE] [varchar](30) NULL,
[PREFIX] [varchar](30) NULL,
[SUFFIX] [varchar](30) NULL,
[MIDDLE_NAMES] [varchar](60) NULL,
[PERSON_TYPE] [varchar](30) NOT NULL,
[PERSON_ID] [int] NOT NULL,
[NATIONAL_IDENTIFIER] [varchar](30) NULL,
[EFFECTIVE_START_DATE] [datetime] NOT NULL,
[EFFECTIVE_END_DATE] [datetime] NOT NULL,
[DATE_EMPLOYEE_DATA_VERIFIED] [datetime] NULL,
[ON_MILITARY_SERVICE] [int] NULL,
[SECOND_PASSPORT_EXISTS] [int] NULL,
CONSTRAINT [PK_hr_persons] PRIMARY KEY CLUSTERED
(
[PERSON_ID] ASC,
[EFFECTIVE_START_DATE] ASC,
[EFFECTIVE_END_DATE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
Still i am facing same problem as collation conflict comes.. above tables script which i am using for this query....
When i right click the database and checked the properties .. collation is SQL_Latin1_General_CP1_CI_AS..... whts going wrong?.. can u suggest me anythg on this pls?