The most recent content from our members.
I would like to have an annotation automatically created when objects (stored procedures, indexes, etc.) are created or changed. Does anyone already have a script to do that? Or, just point me to the DPA table(s) I will need to insert, and I can do it myself.
In SQL server, DDL triggers can be used to trap changes to procedures, indexes etc, and/or modification dates on some objects can be checked periodically. Of course not all such changes will affect performance, so there should be options to prevent or hide the automated annotations, by type or individually. Could also set…
I would rather not grant "Manage Monitoring" to all users that can deploy changes to SQL server, but I would like to encourage them to make annotations when they do so.
I would rather not grant "Manage Monitoring" to all users that can deploy changes to SQL server, but I would like to encourage them to make annotations when they do so. (I will ask a related question about automating annotation creation when objects are changed.)
It looks like you're new here. Sign in or register to get started.