How to log calls and updates of stored procedures

[Orgil]

Hi
I created a database on a remote web server.
I want to know if my stored procedures have been changed or called by
any one such as database admin of the web server.

I tried a tool Profiler. However there is a number of options in
profiler, I can not log exactly what I want.

Pls, write me if you have any suggestion.

... Orgil

[forev...@gmail.com]

Hi,

I could probably had better suggestions if you wrote what you need to
log..
For logging modifications of sproc in SQL 2005 you can use a DDL
Trigger.
I can't think of any other options for detecting calls to a sproc
except using SQL Profiler
or embedding some logging code right inside sproc.

HTH,
Sergey

[Knowledgy]

In profiler, after selecting a new trace, from the drop down menu you can
select the grouped trace (I think it's called t-sql grouped. It has group
in the name). this will capture your stored procedure as they are being
called and group identical calls so that the profiler log doesn't get as big

--
Sincerely,
John K
Knowledgy Consulting
www.knowledgy.org

Atlanta's Business Intelligence and Data Warehouse Experts

"Orgil" <org...@yahoo.com> wrote in message
news:1cd00a4e-228e-4a28...@q39g2000hsf.googlegroups.com...

[Knowledgy]

You could also put an insert statement to an audit into the procedure so
that every time the proc is called an insert is done the audit table

--
Sincerely,
John K
Knowledgy Consulting

http://knowledgy.org/

Atlanta's Business Intelligence and Data Warehouse Experts

"Orgil" <org...@yahoo.com> wrote in message
news:1cd00a4e-228e-4a28...@q39g2000hsf.googlegroups.com...