Error Executing script SQL Server 2008

Asked Feb 14 '12 at 10:19

Active Feb 14 '12 at 10:34

Viewed 459 times

I am trying to execute following script

CREATE TYPE [dbo].[GenericList] AS TABLE(
    [iID] [int] NULL,
    [sKey] [nvarchar](50) NULL,
    [sDescription] [nvarchar](100) NULL,
    [bDelete] [bit] NULL
    )
    GO

but error comes up

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'AS'.

I have not written this it is generated by sql server generate script utility and I am connected to remote server (my webserver) via IP.

on server it is 9.0 RTM Microsoft SQL Server Enterprise Edition but I am using 10.50 on my computer

edited Feb 14 '12 at 10:34

asked Feb 14 '12 at 10:19

Muhammad Umer Asif

The tabbing seems a bit off for a script... What's the database compatibility level? – ta.speot.is Feb 14 '12 at 10:22
Is your remote server SQL Server **2008** as well?? If not - previous versions don't support the user-defined table types – marc_s Feb 14 '12 at 10:23
http://stackoverflow.com/questions/1501596/how-to-check-sql-server-database-compatibility-after-sp-dbcmptlevel-is-deprecate – ta.speot.is Feb 14 '12 at 10:23
on server it is 9.0 RTM `Microsoft SQL Server Enterprise Edition` but I am using 10.50 – Muhammad Umer Asif Feb 14 '12 at 10:30
2

9.0 is SQL Server 2005. You need SQL Server 2008 on the server as well. The version of SQL Server Management Studio does not matter. – Mikael Eriksson Feb 14 '12 at 11:00

Error Executing script SQL Server 2008

0 Answers0