Category: SQL Server

SQL Server Error Code – 21757 the subscription is read-only. the publi

In this blog post, you’ll learn more about the SQL Server Error Code 21757 and the error message description that is shown SQL Server Error Code 21757 SQL Server Error Description for the Code :21757 The subscription is read-only. The publication that this subscription synchronizes with allows updates at the Subscriber, but a value of ‘read-only’ was specified for the @update_mode parameter of sp_addsubscription. To…

How to change the ‘Edit Top 200 Rows’ in SQL Management Studio ?

When working with the SQL Server Management Studio and trying to edit the table records , you would have noticed the context menu option “Edit Top 200 Rows”. How do you change this to display all the records for editing instead of “Edit top 200 rows” in the context menu ? There are couple of ways in which you can do it. 1. Right click…

SQL Server Error Code – 35317 the statement failed because specifying

In this blog post, you’ll learn more about the SQL Server Error Code 35317 and the error message description that is shown SQL Server Error Code 35317 SQL Server Error Description for the Code :35317 The statement failed because specifying %S_MSG is not allowed when creating a columnstore index. Consider creating a columnstore index without specifying %S_MSG.