CODEWITHSUNDEEP
sql-server-2012
Owais F
Owais F

Reputation: 321

Unknown object type error when creating SEQUENCE object

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

Unknown object type 'SEQUENCE' used in a CREATE, DROP, or ALTER statement.

And I don't see anything called Sequences under the Programmability folder for my database.

Upvotes: 5

Views: 8588

Answers (1)

Julien Vavasseur
Julien Vavasseur

Reputation: 3952

What is the output when running the following?

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

Upvotes: 3

Related Questions