Azure SQL Database Msg 40197 Error code 40549.

Applies to: Azure SQL Database

Date created: March 11, 2020.
 

Problem Description.
 

I was updating statistics on a table using SQL Server Management Studio when suddenly I received the following error:

Msg 40197, Level 20, State 1, Line 5
The service has encountered an error processing your request. Please try again. Error code 40549.
Msg 40197, Level 20, State 1, Line 5
The service has encountered an error processing your request. Please try again. Error code 40549.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.






 

Cause.

This error may be originated by a good number of different reasons but this time I received this error on SQL Server Management Studio because an scheduled scale down of the database tier started while I was updating statistics on a big table.

All in-flight transactions are terminated immediately when scaling up or down a database occurs causing any open transactions to be rolled back.

Solution.

Wait for the scaling operation to finish and send the transaction again. In this case, I had to update statistics on the table again.

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.