SQL-Server infinite loop
infinite-loop, sql, sql-server, timeout
Solution
It depends on the client command timeout.
By default, a .net app will abort in 30 seconds and SSMS will wait forever (timeout = zero)
By itself, the SQL Server engine has no concept of "OK, I've had enough"
Problem
how does sql-server handle infinite loops? Does it detect it or kill the server. EG: ``` WHILE (@number = 3) BEGIN print @number END ```