Stored Procedure call failure

tobarich

I need to call a Stored Procedure that copy lines from one table to another. When I execute it from SQL Server it works fine but when I call it from Navision this error appear:

"This message is fo C/AL programmers:

The call to member Execute failes. Microsoft OLE DB Provider for SQL Server returned the following message:
Timeout expired"

I think the problem could be that the source table has 8 millon of registers and I can't delete them because I need them.

If someone knows what to do please let me know. Thanks.

girish.joshi

If you are using the ADO connection object, you can set the timeout parameter. That should take care of your problem.