Paramètre SAP dbs/mss/recompile_par_stmts - Cause every parameterized statement to be recompiled each time it's executed.

Parameter
dbs/mss/recompile_par_stmts

Short text
Recompile every parameterized statement.If this parameter is set then each and every dynamic (parameterized)statement will be different, because a counter is placed in acomment in the statement. This will prevent SQL Server fromre-using the query plan.

Work area
Database

Limitation for os
Windows NT

Limitation for db
Microsoft SQL Server