I have created two stored procedures that I want to be available from all databases on SQL Server 2017. I created them in the master database, used sp_ as the prefix for both of them (e.g.
sp_MyProc2), and then ran
sp_ms_marksystemobject on them to make them system objects.
I can indeed call them from any database and they work as expected.
The problem is that Intellisense doesn’t know that they’re there unless master is the default. It does recognize built in system procedures like
sp_HELP. Is there another setting I need to change to make Intellisense recognize them? We’re using SSMS v17.9. I tried putting them in the
sys schema, but apparently SQL Server doesn’t allow that on master.