errors with complex sp

Dec 14, 2010 at 10:48 AM

I tried to use the procedure and it was great for simple select or sp's but i need it for long and complex sp.

I got two errors:

1. regarding temp table

2. An INSERT EXEC statement cannot be nested

 is there a way to overcome these problems?

Thanks a lot!