Skip to content

Invalid object name 'sys.sequences'. #1

@James-DBA-Anderson

Description

@James-DBA-Anderson

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions