Error in creating a sequence in SQL Server 2005

[jason.3dmagic]

I am trying to create a sequence in SQL Server 2005 following is the sql code

CREATE SEQUENCE SEQ_NAME
MINVALUE 1
MAXVALUE 99999
INCREMENT BY 1
START WITH 1
CACHE 20;

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.

[Tolls]

Um, does SQL Server have sequences?
That's an Oracle thing only, if I'm not mistaken.

[jason.3dmagic]

Hey Tolls,

Thanks, I was not aware of the fact that it is available in Oracle only. But when I googled it i saw many forums showing sequence for SQL Server. I will close this thread.

Regards,
Jason