[thelist] Fw: help! (MsSQL related)

[Nicole Parrot]

Hi evolters.

A friend of mine has requested my help, but it turns out it's outside of my
knowledge too. I don't even know where to start looking on this.

Can someone here help? Here's the info I have.

>>>>
I'm trying to import a database structure and I'm getting an error over and
over that there is a syntax error near "collate"
Here is a portion of the query:
CREATE TABLE [dbo].[TBLFriends] (

[pk] [int] NOT NULL ,

[dtDate] [smalldatetime] NULL ,

[svOrderDeadline] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,

[svCustInquiryNo] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,

[svOrderNum] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[svRollNum] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[svFrameNo] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[svSubtotalA] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[svSubtotalB] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[svSubtotalC] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,



and so on...This sql db is sql 7.0

Any help you have would be soooooo great! I have found no help on msdn.
Thanks!

Tinny

<<<

Nicole