SQL Server System Objects and Intellisense


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_MyProc1 and 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.

Thank You,
Robbie