SQL Server 6.5 Stored Procs

[ColinDow]

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.

[kfleming]

Is it only a specific user name or does it occur with any user name that is passed as the parameter?____Kathleen__R&R Support