Hi,
Apart from running SQL profile continually is there any way to find the SQL associated to a prepared statement.
Also when the prepared statement is executed at run time with sp_execute, DBCC INPUTBUFFER ( spid ) just returns
sp_execute;1
without the parameters. How can the parameters be found ?