You don't have to pay, but you do have to vote! Login and vote now.
By mswatcher
via databasejournal.com
Submitted: May 15 2008 / 12:15
Facets support “On Change – Prevent” if there is transactional support for the DDL statements that change the facet state. Only the Login, User and Database Security facets support the “On Change – Prevent” mode. However, it is usually more important to prevent or correct a violation than just to log it. Fortunately, we can use SQL Server Agent alerts and jobs to remedy the limitations.
Add your comment