Hi Im trying to write a query to set up a mining model, but when I enter any query, even the MS example ones I get a syntax error. The sample query Im trying to run is:

CREATE MINING MODEL [MemberCards]
(
[customer Id] LONG KEY ,
[Yearly Income] TEXT DISCRETE ,
[Member Card Type] TEXT DISCRETE PREDICT,
[Marital Status] TEXT DISCRETE
)
USING Microsoft_Decision_Trees

Query Analyser rteurns this syntax error:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'MINING'.

any ideas what Im doing wrong or what I need to do to execute such a query and set up a mining model