Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NeilG
Aged Yak Warrior
530 Posts |
 Posted - 2009-03-19 : 12:18:43
|
Hi guys, I looking at documenting a database schema and objects i.e. stored proc's, while we are on with this task we've deceided to try and identify any object whether this be tables or objects which are never used, one question that's been posed to me is "is it possible to trace when a stored proc, function or a trigger was executed for a certain time frame"I know this is possible for a stored proc through profiler inserting the results into a table and then a simple count statment to get the amount of time, but is there a way to trace when a function or trigger is called/executed, I'm presuming with a function being different types like a scalar which can be included into a select statement then this would be impossible, but other that filtering a trace to each table that has a trigger for update insert etc then this is going to be a lenghty process.Has anyone looked into something similar to get this type of information or are the other methods to trace objects |
|
|
|
|
|
Tracing certain objects execution