CODEWITHSUNDEEP
databasestored-proceduressql-server-2012infinite-loop
Arkham Knight
Arkham Knight

Reputation: 1

SQL Server : stored procedure infinite loop

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 ?

Upvotes: 0

Views: 931

Answers (1)

TheGameiswar
TheGameiswar

Reputation: 28890

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

Upvotes: 1

Related Questions