Sequences were not implemented until SQL Server 2012. For this reason the SELECT from sys.sequences fails on pre 2012 instances.
The strange thing is that BOL says this table has been present since 2008 but I am unable to see it on my 2008 and 2008R2 instances.
Sequences were not implemented until SQL Server 2012. For this reason the SELECT from sys.sequences fails on pre 2012 instances.
The strange thing is that BOL says this table has been present since 2008 but I am unable to see it on my 2008 and 2008R2 instances.