SQL Server: Create default stored procedure as and when a new database is created
Create the procedure in the system database model.

From model Database


  The model database is used as the template for all databases created
  on an instance of SQL Server.