Migration Azure SQL Database Trace Flag 8017

Question

Hi there,

My SQL Database has a trace flag (8017) and turning the flag off is not possible. I used DBCC TRACEOFF(8017, -1) but it is still ON.

I can't migrate to Azure SQL Database unless this unsupported feature is off.

How I can turn off this trace flag?

Regards, Thomas

Answer 1

For what it's worth, when I run DBCC TRACESTATUS in my Azure SQL Database, there are no less than 31 trace flags turned on, including 8017. I may recognise a few of them, but far from all. I would assume that they are set by the service and they should not be a concern to you.

The trace flag may be undocumented and unsupported for the box product, but it is a different thing you get the database as a service. Then Microsoft is setting this flag for you, which means that by definition it is supported.

As for information for what 8017 does, see Paul White's answer on this thread on Stack Exchange: https://dba.stackexchange.com/questions/48580/trace-flag-and-which-need-to-be-turned-off-and-why

Answer 2

Hi
Thomas •,

Welcome to Microsoft Q&A forum.

As I understand, DBCC TRACEOFF command did not turn off the flag and you are unable to perform migration.

Could you please refer to https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceoff-transact-sql?view=sql-server-ver16 where it is mentioned that it Requires membership in the sysadmin fixed server role.

The issue looks strange, please also share screenshot of the migration error so that we can investigate.

Thanks