Parameter dbs/mss/max_duration Short text maximal runtime for stored procedure executionmaximal runtime for stored procedure executions in millisecondsIf given value is greater than 0 and the execution of a storedprocedure exceeds this value, the recompilation of the storedprocedure is triggered. Work area Database Parameter unit Time (milliseconds) Default value 0 (no maximum) Limitation for os Windows NTMicrosoft SQl Server 7.00 and higher Valid_values <(>><)>= 0 |