Remove warnings when referencing system stored procedures in SQLProj

Question

I use a SQLproj to create a dacpac, and I have stored procedures in it that references systems stored procs.

exec @Result1 = sp_addarticle ....

When I compile, I have warnings :

Warning     SQL71502: Procedure: [dbo].[MyProc] has an unresolved reference to object [dbo].[sp_addarticle].

I changed the call to explicitly define the sys schema

exec @Resultat1 = [sys].[sp_addarticle] ....

but I still have a warning :

Warning     SQL71502: Procedure: [dbo].[PADM_AjoutFonctionPublication] has an unresolved reference to object [sys].[sp_addarticle].

This is a system procedure, so I don't need to add it to the proj, how can I remove these warnings ?

tried adding reference to master database? – dean Jan 13 '17 at 13:09 — dean, Jan 13 '17 at 13:09
how, the warnings are gone ! thanks :) – glacasa Jan 13 '17 at 14:13 — glacasa, Jan 13 '17 at 14:13

score 1 · Accepted Answer · answered Jan 13 '17 at 14:20

1

These errors should go away when you add a reference to the master database.

answered Jan 13 '17 at 14:20

dean

1 Answers1