SQL Server Event Handling: Event Notifications

2016-11-30 0 Comments

SQL Server Event Handling: DDL Events

In the last Event Handling post, I looked at handling SQL Server events synchronously with DDL triggers. However, there are many events that can't be handled synchronously within the scope of a transaction--DDL triggers can't be used for those. Take the AUDIT_CHANGE_DATABASE_OWNER event, for instance. If you attempt to create a DDL trigger for it, you'll get this error:

0 comments:

You Can't Cage The DBCC Beast

2016-11-22 0 Comments

SQL Server DBCC

I ran into a problem with a DBCC command recently. It involved an application running index maintenance on a daily basis. I can appreciate what the software vendor was trying to do. They probably sell their product to a lot of organizations that don't

0 comments: