Category: SQL Server
SQL Server Error Code – 1972 cannot disable clustered index ?%.*ls? o
In this blog post, you’ll learn more about the SQL Server Error Code 1972 and the error message description that is shown SQL Server Error Code 1972 SQL Server Error Description for the Code :1972 Cannot disable clustered index ?%.*ls? on table ?%.*ls?. Permission denied to alter the referencing view ?%.*ls? while disabling its clustered index.
SQL Server Error Code – 4426 view ‘%.*ls’ is not updatable because th
In this blog post, you’ll learn more about the SQL Server Error Code 4426 and the error message description that is shown SQL Server Error Code 4426 SQL Server Error Description for the Code :4426 View ‘%.*ls’ is not updatable because the definition contains a UNION operator.
SQL Server Error Code – 7958 the specified spid does not process inpu
In this blog post, you’ll learn more about the SQL Server Error Code 7958 and the error message description that is shown SQL Server Error Code 7958 SQL Server Error Description for the Code :7958 The specified SPID does not process input/output data streams.
SQL Server Error Code – 11430 cannot enable change data capture on col
In this blog post, you’ll learn more about the SQL Server Error Code 11430 and the error message description that is shown SQL Server Error Code 11430 SQL Server Error Description for the Code :11430 Cannot enable change data capture on column ‘%.*ls’. Change data capture is not supported for encrypted columns.
SQL Server Error Code – 14876 table ‘%.*ls’ cannot be the target of an
In this blog post, you’ll learn more about the SQL Server Error Code 14876 and the error message description that is shown SQL Server Error Code 14876 SQL Server Error Description for the Code :14876 Table ‘%.*ls’ cannot be the target of an update or delete statement through a view because it has the REMOTE_DATA_ARCHIVE option enabled.
SQL Server Error Code – 35297 log backup for database “%.*ls” on secon
In this blog post, you’ll learn more about the SQL Server Error Code 35297 and the error message description that is shown SQL Server Error Code 35297 SQL Server Error Description for the Code :35297 Log backup for database “%.*ls” on secondary replica created backup files successfully but could not ensure that a backup point has been committed on the primary. This is an informational…
SQL Server Error Code – 5221 %.*ls: index allocation map (iam) page %
In this blog post, you’ll learn more about the SQL Server Error Code 5221 and the error message description that is shown SQL Server Error Code 5221 SQL Server Error Description for the Code :5221 %.*ls: Index Allocation Map (IAM) page %d:%d from a dropped allocation unit could not be moved.
SQL Server Error Code – 6621 xml encoding or decoding error occurred
In this blog post, you’ll learn more about the SQL Server Error Code 6621 and the error message description that is shown SQL Server Error Code 6621 SQL Server Error Description for the Code :6621 XML encoding or decoding error occurred with object name ‘%.*ls’.
SQL Server Error Code – 16105 option ‘%.*ls’ is too long (max %d chars
In this blog post, you’ll learn more about the SQL Server Error Code 16105 and the error message description that is shown SQL Server Error Code 16105 SQL Server Error Description for the Code :16105 Option ‘%.*ls’ is too long (max %d chars).
SQL Server Error Code – 46655 rejected rows location
In this blog post, you’ll learn more about the SQL Server Error Code 46655 and the error message description that is shown SQL Server Error Code 46655 SQL Server Error Description for the Code :46655 rejected rows location
SQL Server Error Code – 14875 dml operation failed because it would ha
In this blog post, you’ll learn more about the SQL Server Error Code 14875 and the error message description that is shown SQL Server Error Code 14875 SQL Server Error Description for the Code :14875 DML operation failed because it would have affected one or more migrated (or migration-eligible) rows.
using IN clause to provide a list of values for Search Criteria
In SQL Server , you can use the IN clause to providing the list of values for a search criteria. For example , you want to display the employee records who’s job title is one of the following : ‘Design Engineer’,’Tool Designer’. The above query uses the IN clause to filter the employee records using the arbitrary list of values. Alternatively , you can also…