Unknown object type error when creating SEQUENCE object

Question

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.

Are you sure you are using SQL Server 2012? You might have Management Studio 2012 but you may be connected to a downlevel server. What does SELECT @@VERSION; yield? — Aaron Bertrand
– Aaron Bertrand, Commented Jun 18, 2012 at 15:42
interesting in the help/about section i see Sql Server 2012 Microsoft SQL Server Management Studio 11.0.2100.60 Microsoft Data Access Components (MDAC) 6.1.7601.17514 Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 9.0.8112.16443 Microsoft .NET Framework 4.0.30319.17626 Operating System 6.1.7601 But select @@version gets this: Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) — Owais F
– Owais F, Commented Jun 18, 2012 at 16:02
What you see in about is your client tools. You are obviously connected to a SQL Server 2008. — Mikael Eriksson
– Mikael Eriksson, Commented Jun 18, 2012 at 16:04
but this db is in my local machine in the account created by sql server 2012 the installation wizard — Owais F
– Owais F, Commented Jun 18, 2012 at 16:10
Regardless, you are connected to a SQL Server 2008 instance. Even if you installed SQL Server 2012, check to make sure your are connecting to the right instance that you think is 2012. — user596075
– user596075, Commented Jun 18, 2012 at 16:35

leo.fcx · Accepted Answer · 2015-08-04 15:57:52Z

3

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

leo.fcx

6,4972 gold badges23 silver badges37 bronze badges

answered Aug 4, 2015 at 15:27

Julien Vavasseur

3,9701 gold badge22 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1