Error executing SQL Server CLR "hello world"

Question

When running this sample

CREATE TYPE LocationTableType AS TABLE 
    ( LocationName VARCHAR(50)
    , CostRate INT )
GO

from SQl Manager (SQL Server 9) I get this error:

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

sp_configure 'clr enabled' is already set to 1 and the service was restarted.

What went wrong?

Thanks, P

AakashM · Accepted Answer · 2011-04-13 10:09:08Z

2

(SQL Server 9)

User-defined table types are a feature introduced in SQL Server 2008, version 10.

answered Apr 13, 2011 at 10:09

AakashM

63.5k17 gold badges154 silver badges190 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1