Asking For Help Troubleshooting Sql Code

Hello guys, i am new to sql so forgive me if dont see something in the code that i should. Anyway the code below comes from the sql script that belongs to "BPBlog asp blogging software" ...its not mine.

Whenever i run this code in query analyzer from sql server 2000 i get an error that says :

Server: Msg 170, Level 15, State 1, Line 16
Line 16: Incorrect syntax near '('.


*line 16 is the below line in the code.

i have been going through books online since last night to try to get an understanding of the syntax of all those keywords that sorround the error but still havent figured it out yet. any advise on the error would be sincerely appreciated.

Thanx,





USE [Blog]
GO
/****** Object: Table [dbo].[tblAuthor] Script Date: 11/07/2006 10:51:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblAuthor](
[fldAuthorID] [int] IDENTITY(1,1) NOT NULL,
[fldAuthorUsername] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fldAuthorRealName] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fldAuthorEmail] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fldAuthorWebsite] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fldAuthorBlurb] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fldAuthorPassword] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Approved] [smallint] NULL DEFAULT ((0)),
[fldAdmin] [smallint] NULL DEFAULT ((0)),

CONSTRAINT [aaaaatblAuthor_PK] PRIMARY KEY NONCLUSTERED
(
[fldAuthorID] ASC
)
WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]