Error in creating a sequence in SQL Server 2005
I am trying to create a sequence in SQL Server 2005 following is the sql code
CREATE SEQUENCE SEQ_NAME
INCREMENT BY 1
START WITH 1
But its giving the error as:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'SEQUENCE'.
Msg 319, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.