1

Topic: History of change of indexes and meta data

INTERESTS, whether there is a possibility to trace or to write (as in a case with DDL triggers over DB) changes on indexes? And so that it is more less safe (to write to the data sheet in a separate DB), without accesses in master/msdb.

2

Re: History of change of indexes and meta data

I certainly mean, that it was not under sa. And if under it, with outswapping in out of.

3

Re: History of change of indexes and meta data

[quote = _ Promeshan _] INTERESTS, whether there is a possibility to trace or to write (as in a case with DDL triggers over DB) changes on indexes? And so that it is more less safe (to write to the data sheet in a separate DB), without accesses in master/msdb.

So there are these events in DDL triggers: "create_index, drop_index". Or what it is necessary for you?