Category: SQL Server

SQL Server Error Code – 1901 cannot create index or statistics ?%.*ls

In this blog post, you’ll learn more about the SQL Server Error Code 1901 and the error message description that is shown SQL Server Error Code 1901 SQL Server Error Description for the Code :1901 Cannot create index or statistics ?%.*ls? on view ?%.*ls? because key column ?%.*ls? is imprecise, computed and not persisted. Consider removing reference to column in view index or statistics key…

SQL Server Error Code – 3142 file ?%ls? cannot be restored over the e

In this blog post, you’ll learn more about the SQL Server Error Code 3142 and the error message description that is shown SQL Server Error Code 3142 SQL Server Error Description for the Code :3142 File ?%ls? cannot be restored over the existing ?%ls?. Reissue the RESTORE statement using WITH REPLACE to overwrite pre-existing files, or WITH MOVE to identify an alternate location.

SQL Server Error Code – 41317 a user transaction that accesses memory

In this blog post, you’ll learn more about the SQL Server Error Code 41317 and the error message description that is shown SQL Server Error Code 41317 SQL Server Error Description for the Code :41317 A user transaction that accesses memory optimized tables or natively compiled modules cannot access more than one user database or databases model and msdb, and it cannot write to master.

SQL Server Error Code – 4350 the list of pages provided with the rest

In this blog post, you’ll learn more about the SQL Server Error Code 4350 and the error message description that is shown SQL Server Error Code 4350 SQL Server Error Description for the Code :4350 The list of pages provided with the RESTORE PAGE statement is incorrectly formatted. Prior to the problem %d pages were correctly identified. The problem was hit at character offset %d….

SQL Server Error Code – 22977 unable to update ddl history information

In this blog post, you’ll learn more about the SQL Server Error Code 22977 and the error message description that is shown SQL Server Error Code 22977 SQL Server Error Description for the Code :22977 Unable to update DDL history information to reflect columns changes applied to the tracked table associated with change table ‘%s’. Refer to previous errors in the current session to identify…