I tried both of those methods and they both failed. the Set NoCount On was specified and I called both SQL statements from the same database. What I did find though, was that if I executed a stored procedure that passed no parameters in the @QUERY, then it worked fine, but I tested a few other stored procedures that did require a parameter to be passed and they all failed. Does anyone know why this might be? Was something set up improperly maybe when we migrated to the new server. This procedure was never an issue in 2000.

Thanks!