error en el siguiente script

[Motki]

hola a to2,
tengo este script que en teoria es para sql 7 y me da error al crear la tabla
el script es

Código:

 
CREATE TABLE [dbo].[tblAuthor](
 [fldAuthorID] [int] IDENTITY(1,1) NOT NULL,
 [fldAuthorUsername] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 [fldAuthorRealName] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [fldAuthorEmail] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [fldAuthorWebsite] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [fldAuthorBlurb] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [fldAuthorPassword] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 CONSTRAINT [PK_tblAuthor] PRIMARY KEY CLUSTERED 
(
 [fldAuthorID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

y me da el siguiente error
Servidor: mensaje 170,sintaxis incorrecta cerca de 'COLLATE'. nivel 15, estado 1, línea 3

a que se debe?

[monkyta]

Collation Difference between SQL Server 7.0 and SQL Server 2000In SQL Server 7.0, there was a single collation setting for the server. Each database and column for each table used the same collation setting as the SQL Server 7.0 server setting. With SQL Server 2000, Microsoft has expanded the collation options available. In V2000, the server and each database can now have a different collation settings. Also, each column can have its own collation setting, which can be different from that of the server or database collation. Because SQL Server 2000 supports multiple collation settings, collation issues might arise when migrating databases from SQL Server 7.0 to SQL Server 2000 using the backup and restore method for copying databases.

[claudiovega]

A mi me parece que sql server 7 no acepta collate.

[Mithrandir]

Prueba esto:
CREATE TABLE [dbo].[tblAuthor](
[fldAuthorID] [int] IDENTITY(1,1) NOT NULL,
[fldAuthorUsername] [varchar](100) NOT NULL,
[fldAuthorRealName] [varchar](100) NULL,
[fldAuthorEmail] [varchar](100) NULL,
[fldAuthorWebsite] [varchar](100) NULL,
[fldAuthorBlurb] [varchar](max) NULL,
[fldAuthorPassword] [varchar](100) COLLATE NOT NULL,
CONSTRAINT [PK_tblAuthor] PRIMARY KEY CLUSTERED
(
[fldAuthorID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

[Motki]

gracias por las respuestas...
por lo que he leido el collate solo es poara el 2000 .... he de armamrme de paciencia e ir modificando el script hasta que no salten errores...
Mithrandir, me ha funcionado mas o menos.. me han dado errores pero por otros motivos.. pero si, quitando el collate funciona...