Timeline for SQL Server: Create default stored procedure as and when a new database is created
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 10, 2015 at 20:25 | comment | added | Philippe | That's what I would do too. Other solutions would be to have a scheduled job looking for/creating the SP into each DB at regular intervals. Or you could try for a server-level trigger (forgot the name. DLL or DDL trigger I think) but I never did it myself. | |
| Mar 4, 2015 at 8:48 | vote | accept | Shiva | ||
| Mar 4, 2015 at 8:15 | history | answered | Mikael Eriksson | CC BY-SA 3.0 |