I hop I'm understandin the problem...

When I try it, the USE statement seems to run OK but then revert back to the original database after the execute has run. ...

crosspatch,

I can't agree more. For a couple of years I avoided cursors out of been told they're 'bad form' and inefficient. I'd always found a set based approach...

The is a real elegant way of doing it and very flexible. I use it quite a bit to return detailed messages and also to create T-Sql which has...

Excellent, thanks Antares686. After eliminating sections I found that what I was doing is leaving the <SET NOCOUNT ON> out of the stored proc. One of those things...

I tried them in the past but I'm using using SQL7. (I use SQL2000 query analyser so new of their existance - frustratingly)

Cheers,

Mike