https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-procoption-transact-sql?view=sql-server-ver17
sp_procoption (Transact-SQL) - SQL Server | Microsoft Learn
sp_procoption sets or clears a stored procedure for automatic execution.
sql serversptransactmicrosoftlearn