HanShi (7/17/2013)
Could you rewrite the delete statement to:
DELETE TOP (20) FROM [dbo].[ServerParametersInstance]
WHERE Expiration < @now
This will prevent the query to simultaneously read and delete from the same table.
Hi,
Thanks for the reply.
I did think about this, but it's (as far as I can tell) an internal SSRS procedure and I'm a little nervous about messing with it, although if it works, it works I guess.
As for the host, this is coming from the SSRS instance itself.
I'll keep digging for more info but I think I'll try the modified procedure to see if I can lighten the load a little.