Eine Einführung in

SQL

Set a timeout.

MS SQL Server
Users may accidentally (or deliberately) start queries which would take a very long time to complete. We can set a 'timeout'; this means that the system gives up after a certain amount of time.


Specific to MS SQL Server
The system estimates the time to complete the query before executing it. If this estimate is more than 60 then the query will not be attempted. This applies to all queries. Individual queries may override this value using the SET QUERY_GOVERNOR_COST_LIMIT command.