I have added "WITH RECOMPILE" into my stored procedure and this appears to have fixed it.

This will buy me time whilst I plan and execute the service pack install.

Hi

I have been able to progress this a little.

I may be resolved by installing a hot fix/service pack

http://support.microsoft.com/kb/913371

If I also add "WITH RECOMPILE" to the failign script copied from my...

Hi

I'm not sure if this may help further.

I ran a trace. When it fails to the user I get this

declare @p1 int

set @p1=0

declare @p3 int

set @p3=557064

declare @p4 int

set @p4=98305

declare @p5...