Ben Moorhouse (9/17/2009)

---

I'd love to see (and please let me know if it already exists!) a way to find out when a table was last selected from. We can set up our own logs for statements which affect the data.

With that we could say "lets delete stuff which hasn't been used for a year".

Ben Moorhouse (9/17/2009)

---

Apologies Jason - I meant that I knew we could log changes to objects and data. It's the ability to log select statements which would be incredibly helpful to me.

Not just for housekeeping either, but for identifying people who write bad/inefficient code.

Jason Miller-476791 (9/17/2009)
As far as Steve's idea of "deprecate that" function, I would love to see that.

A backward approach could be made. All of the procedures we have here include insert statements into a logging table. I guess we could search for rows referencing items from sys.procedures and grab those objects not in the logging table. (Unfortunately, we only keep 45 days worth of data)


Couldn't agree more with the need for housekeeping.