How to enable -T1118 trace flag in SQL Server 2012?

sql-server-2012 app-startup
Vikrant More picture Vikrant More · Mar 1, 2014 · Viewed 38.7k times · Source

I am using SQL Server 2012 I would like to enable -T1118 at server level can somebody please help me to enable it?

Answer

CJBS picture CJBS · Mar 1, 2014

SQL Server Configuration Manager can be used to set the SQL Server start-up parameters. You can specify the trace flag there:

  1. Start -> Run -> SQLServerManager11.msc (or just search for SQL Server Configuration Manager)

  2. In SQL Server Configuration Manager, click SQL Server Services.

  3. In the right pane, right-click SQL Server (<instance_name>), and then click Properties.

  4. On the Startup Parameters tab, in the Specify a startup parameter box, type the parameter (in this case the trace flag -T1118), and then click Add.

  5. Click OK.

  6. Restart the Database Engine.

Have a look at this link for details: http://technet.microsoft.com/en-us/library/ms345416.aspx

Related questions

How to check if a column exists in a SQL Server table?

I need to add a specific column if it does not exist. I have something like the following, but it always returns false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') How can …

Read More
Auto increment primary key in SQL Server Management Studio 2012

How do I auto increment the primary key in a SQL Server database table, I've had a look through the forum but can't see how. I've looked the the properties but can't see an option, I have seen an answer …

Read More
Convert Date format into DD/MMM/YYYY format in SQL Server

I have a query in SQL, I have to get a date in a format of dd/mm/yy Example: 25/jun/2013. How can I convert it for SQL server?

Read More