"Which, of course, the 'master' database is the "template" database used whenever you create a new database (thus, the SPs within the 'master' database are automatically created for the databases you create)"

I think this will be model instead of master. Bkz model database works as a template database for all other.

Also, the sysobject view gives us the same results, any difference between sysobjects and all_objects?