Thanks for this.

The reason I know is that this is an old app which the vendor isn't supporting anymore.

Sometimes a data issue occurs and we've been told that a hard-coded SP inside the app is the issue.

Yes, SQL profiler is the clear choice indeed but I figured I'd ask if it happened to exist in tempdb, syscomments or other places.

Many thanks,

Eamon