Why it cannot resolve a refence to main database object in this Database-Project?

Question

I have a database project where there is a stored-procedure spBarFoo.

Whan I try to deploy the project, even though I refer to a table within the data base I work on I receive warnings like:

Warning xx SQL04151: Procedure: [dbo].[spBarFoo] has an unresolved reference to object [Foo].[dbo].[Bar]. D:...\Schema Objects\Schemas\dbo\Programmability\Stored Procedures\spBarFoo.proc.sql

Warning xx SQL04151: Procedure: [dbo].[spBarFoo] has an unresolved reference to object [Foo].[dbo].[Bar].[Id] D:...\Schema Objects\Schemas\dbo\Programmability\Stored Procedures\spBarFoo.proc.sql

Warning xx SQL04151: Procedure: [dbo].[spBarFoo] has an unresolved reference to object [Foo].[dbo].[Bar].[Name] D:...\Schema Objects\Schemas\dbo\Programmability\Stored Procedures\spBarFoo.proc.sql

Warning xx SQL04151: Procedure: [dbo].[spBarFoo] has an unresolved reference to object [Foo].[dbo].[Bar].[Surname] D:...\Schema Objects\Schemas\dbo\Programmability\Stored Procedures\spBarFoo.proc.sql

Here is the citation from the stored-proc:

CREATE PROCEDURE [spBarFoo] @birthDate datetimeoffset
AS

-- Some stuff

INSERT INTO Foo..[Bar](
           [Id]
          ,[Name]
          ,[Surname]

-- Rest of the sp

Question: How can I make Visual Studio to resolve this reference to the Foo..[Bar] ?

Alexander · Accepted Answer · 2012-09-13 09:12:57Z

2

Try to remove explicit database name from procedure. I.e. instead of INSERT INTO Foo..[Bar]( just use INSERT INTO [Bar](.

answered Sep 13, 2012 at 9:12

Alexander

1,3199 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why it cannot resolve a refence to main database object in this Database-Project?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related