Geek Answers Handbook

Unknown object type error when creating a SEQUENCE object

I am trying to create Sequence in SQL Server 2012, but I get this error:

Unknown object type "SEQUENCE" used in the CREATE, DROP, or ALTER statement.

And I do not see anything called Sequences in the Programmability folder for my database.

+4
source share
1 answer

What is the conclusion when starting the following steps?

USE yourDB GO SELECT @@version, compatibility_level FROM sys.databases Where DB_NAME() = name

It should be 110 and Microsoft SQL Server 2012 - 11.XXXXXX

+1
source

More articles:


All Articles