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.
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. :-)