SQL03006 - Unresolved reference

Question

Hi all,

I'm getting

Error    26    SQL03006: Column: [dbo].[vwFirst].[ColFirst] 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: ...

I checked the solutions on the forums, nothing seemed to help.

I created three database projects and two database variables for Database1: $(DB2) and $(DB3) and one for Database2: $(DB3).

My code looks like this: ... FROM [$(DB2)].[dbo].[TblName]

Any help is appreciated.

Answer 1

Nevermind, it was due to the wrong dbschema files.

Answer 2

Hi RasszistaPista,

Glad to hear you have had your issue resolved.

Have a nice day.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us