Ayuda Error en sintaxis

[li3xs]

hola estoy usando el sql server 2005, me salen los siguientes errores creando la siguiente consulta

Código:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo]. [GMInfo] (
[Id] [int] IDENTITY (1,1) NOT NULL,
[GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPart] [nvarchar] (50) NULL COLLATE Latin1_General_CI_AS
) ON [PRIMARY]

CREATE TABLE [dbo]. [GMLog] (
[LogIndex] [int] IDENTITY (1,1) NOT NULL,
[GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[SaveDate] [datetime] NULL,
[Description] [text] COLLATE NULL Latin1_General_CI_AS
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE TABLE [dbo]. [GMLogView] (
[LogIndex] [int] IDENTITY (1,1) NOT NULL,
[GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPart] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[SaveDate] [datetime] NULL,
[Description] [text] COLLATE NULL Latin1_Ge

Código:

Mens. 156, Nivel 15, Estado 1, Línea 7
Sintaxis incorrecta cerca de la palabra clave 'COLLATE'.
Mens. 156, Nivel 15, Estado 1, Línea 14
Sintaxis incorrecta cerca de la palabra clave 'NULL'.
Mens. 156, Nivel 15, Estado 1, Línea 25
Sintaxis incorrecta cerca de la palabra clave 'NULL'.

Plis si alguien me puede ayudar,gracias!

[DALSOM]

ESO ES EL CONJUNTO DE CARACTERES DE TU BASE DE DATOS. BUSCA LA PROPIEDAD collation EN TU BASE DE DATOS, TE RECOMIENDO QUE UTILIZES LA 1252, GENERALMENTE ES LA Latin General Case Insensitive. PERO EL NOMBRE EXACTO NO ME LO SE, AL CREAR TUS TABLAS NO LE PONGAS EL COLLATION, SOLO UTILIZA EL create table(NOMBRECAMPO TIPO(LONGITUD) [PRIMARY KEY]), O MEJOR, UTILIZA EL WIZARD PARA CREAR TABLAS.

POR CIERTO, EL NULLABLE FIELD, VA DESPUES DEL COLLATION. ESE DEBE SER TU ERROR.

INTENTA CON ESTE OTRO, UN POCO MODIFICADO :

CREATE TABLE GMInfo(
[Id] [int] IDENTITY (1,1) NOT NULL,
[GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPart] [nvarchar] (50) COLLATE Latin1_General_CI_AS null
) ON [PRIMARY]

SALUDOS,
DALSOM.

[Andres95]

estaba mal escrito el ultimo renglon de cada tabla..

Código:

CREATE TABLE [dbo]. [GMInfo] (
[Id] [int] IDENTITY (1,1) NOT NULL,
[GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPart] [nvarchar] (50)  COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]

CREATE TABLE [dbo]. [GMLog] (
[LogIndex] [int] IDENTITY (1,1) NOT NULL,
[GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[SaveDate] [datetime] NULL,
[Description] [text] COLLATE Latin1_General_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE TABLE [dbo]. [GMLogView] (
[LogIndex] [int] IDENTITY (1,1) NOT NULL,
[GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPart] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[SaveDate] [datetime] NULL,
[Description] [text]  COLLATE Latin1_General_CI_AS NULL )

Saludos!