SQL Server Database Project is not showing unresolved object reference error

Question

Hello,
I have a problem with SQL Server Database Project in Visual Studio Community 2022 (Version 17.3.5). When I create a blank SQL Server Database Project and add a simple procedure like:

CREATE PROCEDURE [dbo].[SimpleProcedure]
AS
declare @b table(id int)
select dbo.UDF_SomeNotExistingFunction() notExistingColumn
--from @b

and try to compile the project I get a warning saying :

Warning SQL71502: Procedure: [dbo].[SimpleProcedure] has an unresolved reference to object [dbo].[UDF_SomeNotExistingFunction].

That is great.
The problem is that as soon as I uncomment line 'from @b' my warning disappears and I can compile the project without being notified about this kind of issue. It will make a runtime error if is deployed to the SQL Server database.
It also happens when @b is a User Defined Table Type.

Another scenario:
I've added a table to the project:

CREATE TABLE [dbo].[TBL_MyTable]
(
[Id] INT NOT NULL PRIMARY KEY
)

and modified procedure to:

CREATE PROCEDURE [dbo].[SimpleProcedure]
AS
declare @b table(id int)
select
mt.Id MyTableId,
dbo.UDF_NotExistingFunction(mt.Id) notExistingColumn
from [dbo].[TBL_MyTable] mt
--join @b b on b.id=mt.Id

when 'join @b' line is uncommented, MSBuild stops complaining about missing reference to UDF_NotExistingFunction

Answer 1

Hello @Jacek Bala ,

Welcome to Microsoft Q&A forum.

Please try to update Visual Studio 2022 to the latest version and test again. If this issue persists, I suggest you directly report this issue to Visual Studio Product Team on our Developer Community for further investigate and fix.

Thanks for helping us make Visual Studio better.

Sincerely,
Tianyu

• If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
  Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.