execute stored procedure with timeout

Question

Is it possible to execute a stored procedure with a timeout value in SSMS?

Like:

EXEC dbo.StoredProcedureName timeoutValue(not parameter)

Topic also discussed [here](http://stackoverflow.com/questions/3091783/is-it-possible-to-set-a-timeout-for-an-sql-query-on-microsoft-sql-server) — sbiz, Jun 08 '15 at 10:13

score 1 · Accepted Answer · edited May 23 '17 at 11:58

1

As far as I know you can't do this that way. Insted you can configure the generic timeout of the server:

You also can set this on SSMS:

edited May 23 '17 at 11:58

Community

answered Jun 08 '15 at 10:06

Ok thanks. This is not an option for me but at least I know it's not possible then :) – MrProgram Jun 08 '15 at 10:10
You welcome @krillezzz ;) – Cristian Abelleira Jun 08 '15 at 10:22

1 Answers1