list of SPROC's that arnt used

is there any way to get a list of SPROCS that havent been used in oh say the
last year? or are no longer being used in a database on sql server?SQL Server doesn't persist such statistics. You can query syscacheobjects (2
000) or the appropriate
DMV (2005) to see what is in the cache at the moment. And/or use a Profiler
trace to catch which
procedures are used and based on that see which aren't used.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Smokey Grindle" <nospamhere@.dontspam.net> wrote in message
news:%23cunL95cGHA.4312@.TK2MSFTNGP05.phx.gbl...
> is there any way to get a list of SPROCS that havent been used in oh say t
he last year? or are no
> longer being used in a database on sql server?
>|||If you haven't been auditing or tracing the database activity I don't think
you can know what has been used (hit) by connections over the last year. For
future decisions, you could run a trace on the database and then find out
the ones that are being *used*.
Like somebody wiser once suggested, backup all the procedure definitions,
delete the ones you *think* are not being used and wait any for
calls.:):)
Nathan H. Omukwenyi
"Smokey Grindle" <nospamhere@.dontspam.net> wrote in message
news:%23cunL95cGHA.4312@.TK2MSFTNGP05.phx.gbl...
> is there any way to get a list of SPROCS that havent been used in oh say
> the last year? or are no longer being used in a database on sql server?
>|||well I have a trace, I just dont know how to figure out which ones arnt used
"Nathan H. Omukwenyi" <nathan@.e-tools.com> wrote in message
news:OFDjeC6cGHA.3908@.TK2MSFTNGP02.phx.gbl...
> If you haven't been auditing or tracing the database activity I don't
> think you can know what has been used (hit) by connections over the last
> year. For future decisions, you could run a trace on the database and then
> find out the ones that are being *used*.
> Like somebody wiser once suggested, backup all the procedure definitions,
> delete the ones you *think* are not being used and wait any for
> calls.:):)
> Nathan H. Omukwenyi
> "Smokey Grindle" <nospamhere@.dontspam.net> wrote in message
> news:%23cunL95cGHA.4312@.TK2MSFTNGP05.phx.gbl...
>|||Export the trace to a table, and match the one used to the ones in the datab
ase (rather check which
ones you have in the database but not in the trace).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Smokey Grindle" <nospamhere@.dontspam.net> wrote in message
news:euEixX6cGHA.1272@.TK2MSFTNGP03.phx.gbl...
> well I have a trace, I just dont know how to figure out which ones arnt us
ed
>
> "Nathan H. Omukwenyi" <nathan@.e-tools.com> wrote in message
> news:OFDjeC6cGHA.3908@.TK2MSFTNGP02.phx.gbl...
>