CODEWITHSUNDEEP
sql-servertimeoutsettimeoutqsqlquery
Gopal Biswas
Gopal Biswas

Reputation: 419

How to set Timeout for a specific sql query?

I want to set Timeout value for a specific sql query which will execute inside a stored procedure. Is it possible to set the timeout value for a particular query?

Upvotes: 3

Views: 3933

Answers (1)

Dan Guzman
Dan Guzman

Reputation: 46301

It is the client API rather than SQL Server that enforces query timeouts (RPC or batch). Consequently, you can't set a client command timeout at a more granular level when a stored procedure contains multiple statements. You'll need to split the proc such that the desired query is executed separately by the client, and specify a different timeout for that command.

The specifics of how to set the timeout vary depending on the client API. In the case of .NET, it is the SqlCommand.CommandTimeout property.

Upvotes: 1

Related Questions