¿Qué hay de malo con este SQL Create Table Statement?

SQL Server Managment Studio genera esta consulta SQL y me lanza un error:

USE [database_name] GO /****** Object: Table [dbo].[UserAddress] Script Date: 02/17/2010 11:21:02 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[UserAddress] ( [ID] [int] IDENTITY(1,1) NOT NULL, [UserID] [int] NULL, [AddressName] [nvarchar](25) NULL, [Fname] [nvarchar](15) NULL, [LName] [nvarchar](20) NULL, [City] [nvarchar](15) NULL, [Street] [nvarchar](30) NULL, [StreetNum] [nvarchar](5) NULL, [FloorNum] [int] NULL, [AptNum] [int] NULL, [ZipCode] [int] NULL, [Phone] [varchar](15) NULL, [Phone_Prefix] [int] NULL, [CellPhone] [varchar](15) NULL, [CellPhone_Prefix] [int] NULL, [Fax] [varchar](15) NULL, [Fax_Prefix] [int] NULL, [Primary] [bit] NULL, CONSTRAINT [PK_UserAddress] PRIMARY KEY CLUSTERED ( [ID] ASC ) WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF 

El error es: Msg 170, Level 15, State 1, Line 27 Line 27: Incorrect syntax near '('. apuntando a [CellPhone_Prefix] [int] NULL, pero esta línea me parece bien.
¿Qué podría estar mal?
EDITAR:
Acabo de comentar el

  CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED ( [ID] ASC, [ClientStoreID] ASC, [Uname] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 

y ahora funciona, ¿por qué?
EDICION 2:
Lo networkinguje a:

 WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 

¿Me estoy perdiendo de algo?

Creo que esto se debe a la versión de la database del server SQL.

Intenté su consulta utilizando SSMS 2005 en una database SQL Server 2000 y falla con el mismo error que usted describe.

Cuando me conecté a un server SQL Server 2005, la consulta se ejecuta perfectamente.

¿Definitivamente ha revisado su versión de server y no solo su versión de SSMS?

De acuerdo con la syntax de SQL Server 2000 , la parte WITH solo permite que se configure FillFactor, y nada más:

 < table_constraint > ::= [ CONSTRAINT constraint_name ] { [ { PRIMARY KEY | UNIQUE } [ CLUSTERED | NONCLUSTERED ] { ( column [ ASC | DESC ] [ ,...n ] ) } [ WITH FILLFACTOR = fillfactor ] [ ON { filegroup | DEFAULT } ] ] 

Esto difiere de la syntax de SQL Server 2008/2005 que permite múltiples opciones entre paréntesis:

 < table_constraint > ::= [ CONSTRAINT constraint_name ] { { PRIMARY KEY | UNIQUE } [ CLUSTERED | NONCLUSTERED ] (column [ ASC | DESC ] [ ,...n ] ) [ WITH FILLFACTOR = fillfactor | WITH ( <index_option> [ , ...n ] ) ] [ ON { partition_scheme_name (partition_column_name) | filegroup | "default" } ] . . . }