SQL Server: Create default stored procedure as and when a new database is created I am using SQL Server 2008 R2. I need one simple stored procedure to be created by default, as and when a new database is created in SQL Server. How can I achieve this? Assume the stored procedure to be created is

CREATE PROCEDURE [dbo].[Default_SP]
AS
BEGIN
    SELECT GETDATE()
END


Triggers can be applied on the table level. But this is on database create event. I searched over the net and I could not find answers.
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.