mercredi 4 mars 2015

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.





Aucun commentaire:

Enregistrer un commentaire