How to enable trace flag 4199 (in SQL server)
How to enable trace flag 4199
You can enable trace flag 4199 at startup or in a user session. This trace flag has either global-level or session-level effect. To enable trace flag 4199, use the DBCC TRACEON command or use –T 4199 as a startup parameter.If DBCC TRACEON\TRACEOFF is used this does not regenerate a new cached plan for stored procedures. Plans could be in cache that were created without the trace flag.
Reference : https://support.microsoft.com/en-us/kb/974006
Comments
Post a Comment