Hi All.
Not sure if this is even possible but I thought I'd ask
.
Does someone know how to list the date a View in MSSQL 2000 was last used?
I've got a DB which has been hacked around with for a long time and there's loads of views defined that I think I can delete.
However, some of them may be in use either from our front end MS Access user interface, from DB triggers, SPs or nested inside other Views.
If I can see which Views haven't been run in the last year I can delete them safely rather than trawling through loads of code to make sure they're not in use!
Any ideas, suggestions or code gratefully received.
Thanks
M.
Not sure if this is even possible but I thought I'd ask
.Does someone know how to list the date a View in MSSQL 2000 was last used?
I've got a DB which has been hacked around with for a long time and there's loads of views defined that I think I can delete.
However, some of them may be in use either from our front end MS Access user interface, from DB triggers, SPs or nested inside other Views.
If I can see which Views haven't been run in the last year I can delete them safely rather than trawling through loads of code to make sure they're not in use!
Any ideas, suggestions or code gratefully received.
Thanks
M.