Hi ,

I need to create an alert for sending email alerts when schema changed in any databases. Please help me to do this.

At my side:

1. SQL Server 2012 R2 enterprise.
2. 37 databases are there.

You can create a DDL Triggers + sp_send_dbmail (Transact-SQL) for this; see also DDL Events

http://www.codeproject.com/Articles/661119/Send-Email-Alert-on-Database-Schema-Change-in-SQL

Consider using Event Notifications.

I need to create an alert for sending email alerts when schema changed in any databases.

Others have already offered good answers.

But really, changes to your schemas are not the kinds of things you want to discover after the fact, have you considered establishing some security and preventing uncontrolled changes before they happen?

Josh

• Edited by JRStern 10 hours 28 minutes ago

I need to create an alert for sending email alerts when schema changed in any databases.

Others have already offered good answers.

But really, changes to your schemas are not the kinds of things you want to discover after the fact, have you considered establishing some security and preventing uncontrolled changes before they happen?

Josh

• Edited by JRStern Friday, September 11, 2015 8:36 PM