I have a visual basic application (6.0) that runs a stored procedure. This stored procedure (sql server version 7.0) is intense and in the query anayzer takes 20 minutes to run. I have modified the connection timeout and command timeouts in the application to 2700 seconds (45 minutes), yet the application comes back with a timeout after a few minutes (2-3).
For my sanity sake, can anyone help?
THANKS