Skip to content

Unresolved reference to Primary key in update statistics #591

Open
@dhanushyaanbalagan-st

Description

@dhanushyaanbalagan-st
  • SqlPackage or DacFx Version: 162.6.15.1
  • .NET Framework (Windows-only) or .NET Core:
  • Environment (local platform and source/target platforms):

Steps to Reproduce:

  1. Within a stored procedure, we have a script to update statistics on a clustered index that is also a primary key. Eg:
    <update statistics tablename (PK_tablename) with fullscan, norecompute;> This index is not recognized during build.
  2. This happens only for Primary key and throw this error - Procedure: [dbo].[Update_statsProc] has an unresolved reference to object [dbo].[tablename].[PK_tablename]. [C:\buildAgent\work\2c925cf37f27a484\DBB\DBB.sqlproj]

Did this occur in prior versions? If not - which version(s) did it work in?

(DacFx/SqlPackage/SSMS/Azure Data Studio)

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions