I'm kinda angry since the sql problem I am trying to solve was what I downloaded from the book I am using - Visual C# .NET: A Guide for VB6 Developers. (ISBN 1-86100-717-5)CHAPTER 9 - Oh I'm sure I am doing something wrong. I am trying to run this script from the Query Analyzer:

CREATE TABLE [reviewers] (
    [rev_id] [int] IDENTITY (1, 1) NOT NULL ,
    [rev_lname] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [rev_fname] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [phone] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [email] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [address] [char] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [city] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [state] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [zip] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    CONSTRAINT [PK_reviewers] PRIMARY KEY CLUSTERED
    (
        [rev_id]
    ) ON [PRIMARY]
) ON [PRIMARY]
GO


CREATE TABLE [reviews] (
    [reviews_id] [int] IDENTITY (1, 1) NOT NULL ,
    [rev_id] [int] NOT NULL ,
    [title_id] [tid] NOT NULL ,
    [complete] [bit] NOT NULL CONSTRAINT [DF_reviews_complete] DEFAULT (0),
    [dateExpected] [datetime] NULL ,
    CONSTRAINT [PK_reviews] PRIMARY KEY CLUSTERED
    (
        [reviews_id]
    ) ON [PRIMARY]
) ON [PRIMARY]
GO

I get the following error:

Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'COLLATE'.

Any ideas? This stuff needs to be updated to the PUBS database so that I can finish the C# project in the book, (the project is being developed as I progress thru the book so this is a real show stopper!)

Cmarek

__________________
Cmarek

I run this & had no problem!

Always:),
Hovik Melkomian.

What version of SQL Server do you have? COLLATE is only supported on SQL 2000. You can remove all the COLLATE statements and it will run just fine.

I am using sgl server 7. Yep, that was it

Cmarek