SQL Server : stored procedure infinite loop

Question

What will happen to a database server if I execute a stored procedure that contains an erroneous condition, causing an infinite loop? Is there any way for the DBA to detect such a sitution and halt it ?

This post shows no research or effort to answer the question on your part. — dfundako
– dfundako, Commented Apr 11, 2017 at 13:49
Of course you should check any code you write that has a loop to make sure it is not going to go into an infinite loop. — HLGEM
– HLGEM, Commented Apr 11, 2017 at 13:54

TheGameiswar · Accepted Answer · 2017-04-11 13:36:55Z

1

What will happen to a database server if I execute a stored procedure that contains an erroneous condition, causing an infinite loop?

It depends on the query ..query may consume more resources,may cause blockings and many things can happen

Is there any way for the DBA to detect such a sitution and halt it ?

DBA can check for long running queries and kill this query

answered Apr 11, 2017 at 13:36

TheGameiswar

29k9 gold badges67 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server : stored procedure infinite loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related