Tag: MS SQL Server Error Codes

SQL Server Error Code – 21277 cannot publish the source object ‘%ls’.

In this blog post, you’ll learn more about the SQL Server Error Code 21277 and the error message description that is shown SQL Server Error Code 21277 SQL Server Error Description for the Code :21277 Cannot publish the source object ‘%ls’. The value specified for the @type parameter (“indexed view schema only” or “indexed view logbased”) can be used only for indexed views. Either specify…

SQL Server Error Code – 4415 view ‘%.*ls’ is not updatable because ei

In this blog post, you’ll learn more about the SQL Server Error Code 4415 and the error message description that is shown SQL Server Error Code 4415 SQL Server Error Description for the Code :4415 View ‘%.*ls’ is not updatable because either it was created WITH CHECK OPTION or it spans a view created WITH CHECK OPTION and the target table is referenced multiple times…

SQL Server Error Code – 6831 for xml auto requires primary keys to cr

In this blog post, you’ll learn more about the SQL Server Error Code 6831 and the error message description that is shown SQL Server Error Code 6831 SQL Server Error Description for the Code :6831 FOR XML AUTO requires primary keys to create references for ‘%.*ls’. Select primary keys, or use BINARY BASE64 to obtain binary data in encoded form if no primary keys exist.

SQL Server Error Code – 9738 cannot create task for service broker me

In this blog post, you’ll learn more about the SQL Server Error Code 9738 and the error message description that is shown SQL Server Error Code 9738 SQL Server Error Description for the Code :9738 Cannot create task for Service Broker message dispatcher. This message is a symptom of another problem that is preventing SQL Server from creating tasks. Please check the SQL Server error…