How to keep track of changes in views deployed

Database

How to keep track of changes in views deployed

Hi All,

IS there any way to keep track of changes in views deployed in an environment. So that whenever anybody replace a view or update a table, my tracking table should get updated.
I tried to create trigger on the dbc.tables to keep track of it, but as i dont have create trigger rights on DB, i couldn't achieve it.
IS there any work around for the same other than using Trigger. plz suggest.

Thanks in advance.
1 REPLY
Enthusiast

Re: How to keep track of changes in views deployed

Ideally you should be able to achieve it with Change control softwares. otherwise....
May be you can try a simple SQL with help on views / DD table and count or compare the column differences for the result of the previous day. With the access rights u have this appears to be a simple method. :-)