Can i get the query from a StoredProcedure and or triggers

1	I have some stored procedures that i would like to know how gets called. Is it possible to get the query that gets executed from inside the procedure? EX SELECT PROPERTY('QUERY') logging stored-procedure asked 28 May '13, 09:07 Audun 156●10●11●17 accept rate: 0% flat view

One Answer:

You can see the text of stored procedures by viewing the SYS.SYSPROCEDURE system view.

e.g. To see the text for a stored-procedure "sp_targetsp()":

SELECT proc_defn FROM SYS.SYSPROCEDURE WHERE proc_name = 'sp_targetsp'

You may also need to filter by "owner" if there are multiple stored procedures with the same name created by different database users.

If you'd like to see what is being executed inside of a stored procedure at runtime, you can monitor these statements using request-level logging:

dbsrv16 -zr SQL+PROCEDURES -zo rll.txt ...

permanent link

answered 30 May '13, 12:05

Jeff Albion
10.8k●1●71●175
accept rate: 25%

flat view

Your answer

toggle preview

community wiki:

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

Question tags:

question asked: 28 May '13, 09:07

question was seen: 1,702 times

last updated: 30 May '13, 12:11

SAP SQL Anywhere