how to find and turn off a trace flag

  • I did the query -> DBCC TRACEOFF(8017,-1)   but got the message below. I opened sql management as admin and connect sql instance as sa then run the query to turn off then message results below.. I checked trace status and it is still ON. I checked the startup parameter and trace flag is not specified.   How did you fix it and turn off sql traceflag 8017?

    "Ignoring trace flag 8017. It is either an invalid trace flag or a trace flag that can only be specified during server startup.

    DBCC execution completed. If DBCC printed error messages, contact your system administrator."


    My SQL Express version below:

    Microsoft SQL Server 2014 (SP3) (KB4022619) - 12.0.6024.0 (X64)

    Sep 7 2018 01:37:51

    Copyright (c) Microsoft Corporation

    Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply