lundi 15 août 2016

Using SQL Profiler to get the name of stored procedures

I have a database with almost a thousand of stored procedures and I want to know which stored procedure is called after a button is clicked. I try to use SQL Profiler (version 8.0) to capture the name of the stored procedure, but it seems it's not possible to get the name directly from SQL Profiler.

A tutorial says I can get the stored procedure name by running:

Select name from sysobjects where id = <ObjectID>

I tried by the id matched nothing. How can I get the name of the stored procedure?

Thanks

Aucun commentaire:

Enregistrer un commentaire