Wednesday, April 8, 2009

Can I find past queries from the sysobjects table?

Is there any way to look in logs, or to set up logs, that will track historical queries into the sysobjects table? The intruders seem to always be going after this table first to find our schema - is there any way to tell when a query was directed against that table?

Profiler would work for future statements only...but it would work great for them. But... you're not going to be able to get at the past select statements

No comments: