Sql timeout

  • 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

  • I can't help you with your post, but I can tell you that you posted it in a really improper forum. This is for JOB (ie. work) postings. Like: I'm an SQL DBA and need a job. Or I am looking to hire an SQL DBA.

    -SQLBill

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply