Home / Questions / 81204
Accepted
Ariel Octavio D'Alfeo
Asked: 2020-06-24 16:00:23 +0800 CST 2020-06-24 16:00:23 +0800 CST

Modify MS SQL SERVER startup parameters from console

  • 772

I have a problem with SQL Server 2012+ that made a change in the Identityand it jumps by 1000 with every reboot, this article explains well how to disable trace flag 272.

I would like to know if it is possible to make a .bat that, through the SQL Server console, deactivates the indicator.

sql-server

1 Answers

  1. Best Answer

    To activate a global trace flag use the following command:

    dbcc traceon (272,-1)

    traceon, enable trace flag 272, it is the flag that mentions the page you included, -1it is to be global throughout the server, not just in the session.

    If you want to disable it use:

    dbcc traceoff (272,-1)

    To see what is running use:

    DBCC TRACESTATUS(-1);

    As with any traceflag , check it out before you implement it to make sure it will solve the problem.

    • 2