Category: SQL Server
SQL Server Error Code – 6878 forxml xmlschema cannot be used with a t
In this blog post, you’ll learn more about the SQL Server Error Code 6878 and the error message description that is shown SQL Server Error Code 6878 SQL Server Error Description for the Code :6878 FORXML XMLSCHEMA cannot be used with a typed XML column whose schema collection is empty.
SQL Server Error Code – 8628 a time out occurred while waiting to opt
In this blog post, you’ll learn more about the SQL Server Error Code 8628 and the error message description that is shown SQL Server Error Code 8628 SQL Server Error Description for the Code :8628 A time out occurred while waiting to optimize the query. Rerun the query.
SQL Server Error Code – 17888 all schedulers on node %d appear deadloc
In this blog post, you’ll learn more about the SQL Server Error Code 17888 and the error message description that is shown SQL Server Error Code 17888 SQL Server Error Description for the Code :17888 All schedulers on Node %d appear deadlocked due to a large number of worker threads waiting on %ls. Process Utilization %d%%.
SQL Server Error Code – 49905 error %u occurred while opening paramete
In this blog post, you’ll learn more about the SQL Server Error Code 49905 and the error message description that is shown SQL Server Error Code 49905 SQL Server Error Description for the Code :49905 Error %u occurred while opening parameters file ‘%s’. Verify that the file exists, and if it exists, verify that it is a valid parameters file.
SQL Server Error Code – 871 buffer pool extension size from rg setti
In this blog post, you’ll learn more about the SQL Server Error Code 871 and the error message description that is shown SQL Server Error Code 871 SQL Server Error Description for the Code :871 Buffer pool extension size from RG Setting is %d GB (%I64d bytes).
SQL Server Error Code – 5161 an unexpected file id was encountered. f
In this blog post, you’ll learn more about the SQL Server Error Code 5161 and the error message description that is shown SQL Server Error Code 5161 SQL Server Error Description for the Code :5161 An unexpected file id was encountered. File id %d was expected but %d was read from “%.*ls”. Verify that files are mapped correctly in sys.master_files. ALTER DATABASE can be used…
SQL Server Error Code – 9978 warning: during upgrade full-text index
In this blog post, you’ll learn more about the SQL Server Error Code 9978 and the error message description that is shown SQL Server Error Code 9978 SQL Server Error Description for the Code :9978 Warning: During upgrade full-text index on table ‘%ls’ is disabled because at least one of full-text key column, full-text columns, or type columns is a non-deterministic or imprecise nonpersisted computed…
SQL Server Error Code – 17143 %s: could not set service control status
In this blog post, you’ll learn more about the SQL Server Error Code 17143 and the error message description that is shown SQL Server Error Code 17143 SQL Server Error Description for the Code :17143 %s: Could not set Service Control Status. Operating system error = %s.
SQL Server Error Code – 25023 stored procedures containing table-value
In this blog post, you’ll learn more about the SQL Server Error Code 25023 and the error message description that is shown SQL Server Error Code 25023 SQL Server Error Description for the Code :25023 Stored procedures containing table-value parameters cannot be published as ‘[serializable] proc exec’ articles.
SQL Server Error Code – 35393 columnstore tuple mover unit tests can’t
In this blog post, you’ll learn more about the SQL Server Error Code 35393 and the error message description that is shown SQL Server Error Code 35393 SQL Server Error Description for the Code :35393 Columnstore tuple mover unit tests can’t be run under master database.
SQL Server Error Code – 4904 alter table switch statement failed. the
In this blog post, you’ll learn more about the SQL Server Error Code 4904 and the error message description that is shown SQL Server Error Code 4904 SQL Server Error Description for the Code :4904 ALTER TABLE SWITCH statement failed. The specified partition %d of target table ‘%.*ls’ must be empty.
SQL Server Error Code – 10634 an ‘%.*ls’ statement was executed on obj
In this blog post, you’ll learn more about the SQL Server Error Code 10634 and the error message description that is shown SQL Server Error Code 10634 SQL Server Error Description for the Code :10634 An ‘%.*ls’ statement was executed on object ‘%.*ls’ by hostname ‘%.*ls’, host process ID %d using the WAIT_AT_LOW_PRIORITY options with MAX_DURATION = %d and ABORT_AFTER_WAIT = BLOCKERS. Blocking user sessions…
SQL Server Error Code – 14550 command-line subsystem
In this blog post, you’ll learn more about the SQL Server Error Code 14550 and the error message description that is shown SQL Server Error Code 14550 SQL Server Error Description for the Code :14550 Command-Line Subsystem
SQL Server Error Code – 21152 cannot create a subscription of sync_typ
In this blog post, you’ll learn more about the SQL Server Error Code 21152 and the error message description that is shown SQL Server Error Code 21152 SQL Server Error Description for the Code :21152 Cannot create a subscription of sync_type ‘none’ to a publication using the ‘concurrent’ or ‘concurrent_c’ synchronization method.
SQL Server Error Code – 40140 set partition failed since a different p
In this blog post, you’ll learn more about the SQL Server Error Code 40140 and the error message description that is shown SQL Server Error Code 40140 SQL Server Error Description for the Code :40140 Set partition failed since a different partition already was set in the current transaction. Cross partition operations within a node are not reliable or supported.
SQL Server Error Code – 3406 %d transactions rolled forward in databa
In this blog post, you’ll learn more about the SQL Server Error Code 3406 and the error message description that is shown SQL Server Error Code 3406 SQL Server Error Description for the Code :3406 %d transactions rolled forward in database ?%.*ls? (%d:%d). This is an informational message only. No user action is required.
SQL Server Error Code – 7610 access is denied to “%.*ls”, or the path
In this blog post, you’ll learn more about the SQL Server Error Code 7610 and the error message description that is shown SQL Server Error Code 7610 SQL Server Error Description for the Code :7610 Access is denied to “%.*ls”, or the path is invalid.
SQL Server Error Code – 7996 extended stored procedures can only be c
In this blog post, you’ll learn more about the SQL Server Error Code 7996 and the error message description that is shown SQL Server Error Code 7996 SQL Server Error Description for the Code :7996 Extended stored procedures can only be created in the master database.
SQL Server Error Code – 11536 execute statement failed because its wit
In this blog post, you’ll learn more about the SQL Server Error Code 11536 and the error message description that is shown SQL Server Error Code 11536 SQL Server Error Description for the Code :11536 EXECUTE statement failed because its WITH RESULT SETS clause specified %d result set(s), but the statement only sent %d result set(s) at run time.
SQL Server Error Code – 14256 cannot start the job “%s” (id %s) becaus
In this blog post, you’ll learn more about the SQL Server Error Code 14256 and the error message description that is shown SQL Server Error Code 14256 SQL Server Error Description for the Code :14256 Cannot start the job “%s” (ID %s) because it does not have any job server or servers defined. Associate the job with a job server by calling sp_add_jobserver.