|
Home > Archive > MS SQL Server > October 2006 > Do some statistics on calling a specific stored function
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Do some statistics on calling a specific stored function
|
|
|
| Dear all,
We would like to keep a counter on how many time a specific stored fuction
is called.
At first, we want to add this counter inside the function but update record
to table is not allow in stored function.
Is there any other method to do so?
Ivan
| |
| Hilary Cotter 2006-10-28, 7:14 pm |
| You could run profiler, or you can have audit statements before the function
is called if it is within a proc.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ivan" <ivan@microsoft.com> wrote in message
news:uF76fgk%23GHA.1752@TK2MSFTNGP02.phx.gbl...
> Dear all,
>
> We would like to keep a counter on how many time a specific stored fuction
> is called.
>
> At first, we want to add this counter inside the function but update
> record to table is not allow in stored function.
>
> Is there any other method to do so?
>
> Ivan
>
|
|
|
|
|