Parameter
dbs/mss/par_stmt_prepare
Short text
MSSQL: Prepare parameterized statements
Parameter Description
When this parameter is turned off, DBSL will stop preparing SQL statements. This means the profiler trace will show sp_executesql instead of sp_prepexec or sp_prepare and then sp_execute. This will allow a clearer profiler trace because the statement text will always be visible.
Application Area
Database
Parameter Unit
0/1
Default Value
1
