Category: SQL Server
SQL Server Error Code – 40064 attempt to add a csn to an invalid csn v
In this blog post, you’ll learn more about the SQL Server Error Code 40064 and the error message description that is shown SQL Server Error Code 40064 SQL Server Error Description for the Code :40064 Attempt to add a CSN to an invalid CSN vector. The new CSN is (%d,%I64d), the current CSN is (%d,%I64d).
SQL Server Error Code – 40976 instance failover group cannot be create
In this blog post, you’ll learn more about the SQL Server Error Code 40976 and the error message description that is shown SQL Server Error Code 40976 SQL Server Error Description for the Code :40976 Instance Failover Group cannot be created because partner managed server “%.*ls” is not empty or does not have secondaries for all databases in the primary instance “%.*ls” .
Sorting the Data in a Query in SQL Server
You want the results of the query to be displayed in a sorted order based on some query. In this case , you use the ORDER BY clause in the query by specifying the column on which the sort to work. For example , you want to sort the Departments table in the database by the column DepartmentName. Here’s how the query looks like This…
SQL Server Error Code – 4928 cannot alter column ‘%.*ls’ because it i
In this blog post, you’ll learn more about the SQL Server Error Code 4928 and the error message description that is shown SQL Server Error Code 4928 SQL Server Error Description for the Code :4928 Cannot alter column ‘%.*ls’ because it is ‘%ls’.
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.