Showing posts with label valued. Show all posts
Showing posts with label valued. Show all posts

Wednesday, March 7, 2012

can SQL Profiler ('05) look into User Defined Functions (UDFs)?

particularly table valued UDFs that may cause other udfs, etc.

what settings/events do I need to see inside and get each statement or at least each seperate UDF that is executed internally?

Try SP:StmtStarting, SP:StmtCompleted events. They are under "Stored Procedures" event category.