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