How to enable the trace flag?

I

Ilya2015-11-10 08:17:29

SQL

Ilya, 2015-11-10 08:17:29

Please tell me how to enable the trace flag (1400) on sql server 2005 so that it is always enabled

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

I

Ilya, 2015-11-10
@il_orehov

Issue resolved. Configuration manager => sql server properties => advanced => add -T1400 to startup parameters. You should get something like:
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf; -eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG ;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf; -T1400