<p>I have found that SP2 doesn't execute from within SP1 when SP1 is executed.</p>

<p>Below is the structure of SP1:</p>

<pre><code>ALTER PROCEDURE SP1 AS BEGIN

Declare c1 cursor....

open c1 fetch next from c1 ...

while @@fetch_status = 0 Begin

...

Fetch Next from c1 end

close c1

deallocate c1

exec sp2

end
</code></pre>

<hr>

<p>I see non of the PRINT statement outputs if they are printed in the 'Output window' in SQL Server 2005 management studio as the 'Output Window'is empty.</p>

What happens if you run the Stored Procedure code as a single query? If you put a
```
PRINT
```
statement before and after the exec, do you see both outputs?
If you do, then the stored procedure must have been executed. Probably it's not doing what you would like.
If you don't see any print output, then there's something wrong in the cycle
If you don't see the second output but you see the first, there's something wrong in the second Stored Procedure.