Is it possible to establish what SPID is calling a stored proc? I have a stored proc that is being executed every few minutes but I've no idea by what or by whom. There are no reports associated with the proc as fair as I can tell and there are no dependencies showing anywhere. Is there any way to find out what is executing it?
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537