If it worked previously, then you weren't trying to nest INSERT ... EXEC as they cannot be nested under any circumstances. You're going to have to figure out an alternative way of doing things that doesn't require nesting them
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability