SQL Server Error Code – 28074 service broker could not upgrade convers

In this blog post, you’ll learn more about the SQL Server Error Code 28074 and the error message description that is shown

SQL Server Error Code

28074

SQL Server Error Description for the Code :28074

Service Broker could not upgrade conversation with conversation_handle ‘%ls’. Use END CONVERSATION … WITH CLEANUP to delete this conversation, then try again to enable the broker. Use ALTER DATABASE … SET ERROR_BROKER to error all conversations in this database. Use ALTER DATABASE … SET NEW_BROKER to delete all conversations in this database.