I have a stored procedure that executes a couple of queries. Each query might fail because of a timeout.
I still want to continue to execute the other queries. Is this possible? Does a try catch work for timeouts?
I can offcourse have different sps for each query, but that would make the application more complex.
See Question&Answers more detail:os
How you run the SQL?
SQL itself has no timeout, so what you describe as a problem is not possible.
The timeout is always handled on the connection level / connecting application. SQL Server is happy having SQL calls that last for hours or days.
So, unless you do sometihing "funny" / unusual the queries within the SP will not time out - the connection that calls the procedure will time out and thus rollback the transaction.
