question

cprplano2011 avatar image
cprplano2011 asked

Email alerts after any changes made in Sql Server Database

Is there anyway I can create trigger or any email notification after any changes made in Database for example after any updates or changes in stored Proc, function, views.
sqlserver
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
DenisT avatar image
DenisT answered
You sure can! It's called a DDL trigger -- [SQL Server DDL Triggers to Track All Database Changes][1] [1]: http://www.mssqltips.com/sqlservertip/2085/sql-server-ddl-triggers-to-track-all-database-changes/
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.