SQL Server 6.5 Stored Procs
Posted: Wed Mar 07, 2007 10:40 am
We have a report running against SQL Server 6.5.__Its based on a stored proc that takes one parameter____We are experiencing some rather odd behaviour. The SP always seem to run fine in enterprise manager. However, a certain value for the parameter (its a users name) seems to bring the RR report to a halt (9 times out of 10). Once this happens we have to recompile the procedure to get things going again.____The dataset returned for this value of the parameter is not significantly different from that returned by other values we pass in.____Appreciate this is not strictly an RR question but its the first time I^ve seen this behaviour - as EM works fine I guess it could be something in the ODBC layer that is creating a problem.