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?