[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Azure SQL Database Msg 40197 Error code 40549

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

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.