• You could try looking at @@NESTLEVEL is you know definitely that either A is called directly or B calls A. Of course, if a hypothetical procedure C also calls A then the level won't help.

    See http://msdn.microsoft.com/en-us/library/aa933163(SQL.80).aspx

    Derek