SQL Ouery Timeout error…

Solutions to cBiz Timeout error…

Problem:

You are getting a timeout error and want to increase the timeout to run a stored procedure or a query.

Solution:

In the SQL Server Enterprise Manager, open the SQL Server Properties (properties for the entire server) by right mouse clicking the server node in the tree. Select the Connection tab and set Query Timeout as desired. You can set the query timeout to 0 for indefinite or no timeout.