How can I take advantage of the enhancement for error 8152 (https://blogs.msdn.microsoft.com/sql_server_team/string-or-binary-data-would-be-truncated-replacing-the-infamous-error-8152/) in Azure SQL Database? Even when logged in as the Server admin, I can't set the trace flag.
asked Dec 2 '19 at 22:37
Add a comment
|
You cannot enable traceflags in azure sql database (single database).
You can enable traceflags when using azure sql database managed instances:
Since the azure sql database service is based on the latest stable sql server version
It's (azure sql database) based on the latest stable version of the Microsoft SQL Server database engine.
Azure sql database service documentation
And in your linked source it is stated that:
...Note that for now, even in SQL Server 2019 CTP 2.0 the same trace flag 460 needs to be enabled. In a future SQL Server 2019 release, message 2628 will replace message 8152 by default....
We should hope to see this more detailed error message enabled by default for the azure sql database service in the future, once that build is deemed stable.
answered Dec 3 '19 at 8:15
-
It's now March 2021 and it still doesn't seem like it's possible to use Trace 460 with Azure SQL :/ – Dai Mar 5 at 2:07
