SQL Server database project gives warning 'Unresolved reference to object sp_executesql'

Question

SQL Server database project gives warning 'Unresolved reference to object sp_executesql' when using sp_executesql inside a stored procedure.

Demetrius

Answer 1

Expand references under your database and add reference to system database 'master'

Demetrius

And if you're working in a team, make sure everyone is on the same edition of Visual Studio so the path to that master.dacpac file is consistent. (i.e., no mixing "community" with "pro" with "enterprise") For some reason, MS placed those dacpacs inside that edition-specific path instead of a generic one. :/ – Toxemia