Henrico Bekker (4/16/2012)
got it wrong, as the correct answer wasn't listed.your syntax is wrong in, sequence wouldn't be created to start of with...no increment value, no 'AS'..etc.
The CREATE SEQUENCE page in Bol gives an example in which the sequence is created by
CREATE SEQUENCE Test.TestSequence ;
so clearly MS thinks that not specifying any of those things works.
Tom