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.