Unanswered: Crystal Reports w/ SQL Server stored proc
I am having a difficult problem to correct.
I have created a stored procedure, which has three parameters: int, datetime, datetime. It works fine when executed from Query Analyzer, but it when I use it as a source in Crystal (using OLE DB), Crystal hangs.
When using Enterprise Manager, the exec uspSJAPercentageLeakers command has been launched, but it is hung, and it has a lock on a TON of tables. When running a trace, it is constantly displaying "Lock: Aquired" or "Lock: Released".
However, it sporadically works from time to time...
Has someone else run into this? If so, what was causing the problem / done to fix it?