We've got a strange problem here and I'm hoping someone has some kind of idea as to what could be causing it.We've got a stored procedure in Sql Server 2005. It's not terribly complicated but it's ...

The stored procedure builds dynamic SQL. Doh!<BR><BR>Changed the dynamic sql within the SP to be parameterized and it works like a charm now.<BR><BR>Thanks! More options ...