[thelist] Fw: help! (MsSQL related)

[rudy]

>... syntax error near "collate"
>
> [svCustInquiryNo] [nvarchar] (50)
>      COLLATE SQL_Latin1_General_CP1_CI_AS
>    NULL

hi nicole

one of the sql/server guys should really answer this, but i'll bet it would
be totally safe just to remove the collate clause (search & replace would
do it)

> [svCustInquiryNo] [nvarchar] (50)
>    NULL

latin is probably the target server's default

all those square brackets are required only if the name contains special
characters, so i'm guessing this stuff was created by a utility program of
some sort which read the details out of the originating schema's
database -- i guess it must've read out the collating sequence by default,
or something

rudy