I Need Help !!!! Incorrect syntax near 'COLLATE'.

[bmann]

I generated a sql script for a table. I am trying to recreate table and get an error 'Incorrect syntax near 'COLLATE'. I have never seen this before. I need someone's help.

 

[SQLSister]

Please post the code

 

[bmann]

Thanks for responding. Here is the code.

CREATE TABLE [dbo].[FILE_CONFIG] (
[REC_ID] [int] NOT NULL ,
[SOURCE_PATH] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ARCHIVE_PATH] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

 

[SQLSister]

Well that worked on my machine when I tested it. But this also worked, maybe it will work for you.
CREATE TABLE [dbo].[FILE_CONFIG] (
[REC_ID] [int] NOT NULL ,
[SOURCE_PATH] [varchar] (50) NULL ,
[ARCHIVE_PATH] [varchar] (50) NULL
) ON [PRIMARY]
GO

 

[bmann]

Thanks. I did the same thing and it worked. But all I did was generate a sql script from a previous table. This has not happen before. Thanks anyway.

Brian