Unfortunately I cannot upgrade our production server for another 6 months - so am stuck with 2005.
But my main issue - is the fact that it is workign fine under a Trigger - but not a Stored Procedure.
Thanks for any help.
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.