Hi Bonnie,

The problem we were having was a parameter sniffing issue. Apparently the optimiser in 2005 is misreading one (or more) of the parameter types or values.

The thread we used to resolve this is

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=360&messageid=354539

although you will have to sign up to view it (it is free though)

Thanks
Steve