Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlmyworld
Starting Member
38 Posts |
 Posted - 2012-09-11 : 21:07:04
|
| Does anyone know how to enable Trace Flag T1118 as a start up parameter?What I did -- I open SQL Server Configuration Manager and on SQL Server Service - go to Property -advance tab - Startup parameter. I entered "-T1118" to existing parameter. -dE:\ServerName\MSSQL\DATA\master.mdf;-eE:\ServerName\MSSQL\Log\ERRORLOG;-lE:\ServerName\MSSQL\DATA\mastlog.ldf; -T1118Is above method correct to set up trace flag as startup parameter? Can anyone please confirm?Thanks in Adv. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-14 : 15:36:58
|
| Yes-Chad |
 |
|
|
bstudley
Starting Member
1 Post |
Posted - 2013-07-22 : 16:21:34
|
| the new start up parameter should not have any spaces after the semicolon in the text:-dE:\ServerName\MSSQL\DATA\master.mdf;-eE:\ServerName\MSSQL\Log\ERRORLOG;-lE:\ServerName\MSSQL\DATA\mastlog.ldf;-T1118the -T#### will be ignored otherwise.-- Bill |
|
|
|
|
|
|
Enable Trace Flag T1118