Stored Procedure Usage

microsoft.public.sqlserver.tools

15 Dec 2005 2:30 PM

Susanna

Is there something that can check the usage of a stored procedure?

15 Dec 2005 4:37 PM

Tibor Karaszi

You mean who executes it, when and how often? Either have a profiler trace running with appropriate
events, columns and filters. Or modify the procedure so it logs the needed information to a table.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"Susanna" <Susa***@discussions.microsoft.com> wrote in message
news:2CFAFEA4-A70C-445F-ADA8-E2394922F914@microsoft.com...
> Is there something that can check the usage of a stored procedure?