sp_prepexec syscomments?

sp_prepexec syscomments?

am 18.04.2008 12:56:23 von codefragment

Hi
I'm sure lots of people have asked this before, but I can't find any
threads so:

Assuming you haven't had your profiler open for long enough is there
any way of getting to the procedure
code that was prepared with sp_prepexec in query analyser?
If not why not? (I'm sure theres a good reason but I'd like to know)

thanks

C