none
SQL Server Data Tool : SQK71501 Procedure contains an unresolved reference to an object.

    Question

  • Hi there,

    From VS2012 I created a Database project and import scripts from local PC. When I built project, I got the following compiling errors:

    *******************************************************************************************************

    Error 198 SQL71501: Procedure: [dbo].[GetReportHistory2] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[ReportHistory].[LastName] or [dbo].[UserProfile].[LastName]. C:\MyProjects\DatabaseProject\Database.SQL.WithData\dbo\Stored Procedures\GetReportHistory2.sql 79 4 Database.SQL.WithData

    *******************************************************************************************************

    When I tried to create and import on some other PCs, everything works well.

    How to solve the above problem?

    Thank you very much in advance for your support.

    Anna

    Thursday, July 11, 2013 10:08 PM

All replies

  • Hi Anna,

    You have raised your question in an incorrect forum. Let me try to move this post to the SQL Programming forum.

    Thanks,

    Gaurav

    Friday, July 12, 2013 9:37 PM