All the objects that exist in the database called "model" are always included in all new databases that you create. You can add a stored procedure to the database called "model", so the next time you create a new database, this stored procedure will exist in that new database.