Category: SQL Server
SQL Server Error Code – 413 correlated parameters or sub-queries are
In this blog post, you’ll learn more about the SQL Server Error Code 413 and the error message description that is shown SQL Server Error Code 413 SQL Server Error Description for the Code :413 Correlated parameters or sub-queries are not supported by the inline function ?%.*ls?.
SQL Server Error Code – 9830 %ls cannot be less than zero.\nparameter
In this blog post, you’ll learn more about the SQL Server Error Code 9830 and the error message description that is shown SQL Server Error Code 9830 SQL Server Error Description for the Code :9830 %ls cannot be less than zero.\nParameter name: %ls.
SQL Server Error Code – 14128 invalid @subscription_type parameter val
In this blog post, you’ll learn more about the SQL Server Error Code 14128 and the error message description that is shown SQL Server Error Code 14128 SQL Server Error Description for the Code :14128 Invalid @subscription_type parameter value. Valid options are ‘push’ or ‘pull’.
SQL Server Error Code – 15007 ‘%s’ is not a valid login or you do not
In this blog post, you’ll learn more about the SQL Server Error Code 15007 and the error message description that is shown SQL Server Error Code 15007 SQL Server Error Description for the Code :15007 ‘%s’ is not a valid login or you do not have permission.
SQL Server Error Code – 19035 ole task allocator failed to initialize.
In this blog post, you’ll learn more about the SQL Server Error Code 19035 and the error message description that is shown SQL Server Error Code 19035 SQL Server Error Description for the Code :19035 OLE task allocator failed to initialize. Heterogeneous queries, distributed queries, and remote procedure calls are unavailable. Confirm that DCOM is properly installed and configured.
SQL Server Error Code – 30077 the full-text query did not use the valu
In this blog post, you’ll learn more about the SQL Server Error Code 30077 and the error message description that is shown SQL Server Error Code 30077 SQL Server Error Description for the Code :30077 The full-text query did not use the value specified for the OPTIMIZE FOR query hint. Only single terms are allowed as values for full-text queries that contain an OPTIMIZE FOR…
SQL Server Error Code – 47014 reason: fedauth rps authentication faile
In this blog post, you’ll learn more about the SQL Server Error Code 47014 and the error message description that is shown SQL Server Error Code 47014 SQL Server Error Description for the Code :47014 Reason: FedAuth RPS Authentication failed when fetching MemberId High.
SQL Server Error Code – 13239 group by
In this blog post, you’ll learn more about the SQL Server Error Code 13239 and the error message description that is shown SQL Server Error Code 13239 SQL Server Error Description for the Code :13239 GROUP BY
SQL Server Error Code – 35453 it is a system database. make sure to ta
In this blog post, you’ll learn more about the SQL Server Error Code 35453 and the error message description that is shown SQL Server Error Code 35453 SQL Server Error Description for the Code :35453 it is a system database. Make sure to target a user database. If you want temporary clustered columnstore tables, consider creating a regular user database for them
SQL Server Error Code – 5854 a %s_msg value was specified more than o
In this blog post, you’ll learn more about the SQL Server Error Code 5854 and the error message description that is shown SQL Server Error Code 5854 SQL Server Error Description for the Code :5854 A %S_MSG value was specified more than one time in the range list for an ALTER SERVER CONFIGURATION SET PROCESS AFFINITY statement.
SQL Server Error Code – 27012 cannot delete token. error tolerant ind
In this blog post, you’ll learn more about the SQL Server Error Code 27012 and the error message description that is shown SQL Server Error Code 27012 SQL Server Error Description for the Code :27012 Cannot delete token. Error Tolerant Index is corrupt.
SQL Server Error Code – 40307 cannot find index %ld on object %ld.
In this blog post, you’ll learn more about the SQL Server Error Code 40307 and the error message description that is shown SQL Server Error Code 40307 SQL Server Error Description for the Code :40307 Cannot find index %ld on object %ld.
SQL Server Error Code – 401 unimplemented statement or expression %l
In this blog post, you’ll learn more about the SQL Server Error Code 401 and the error message description that is shown SQL Server Error Code 401 SQL Server Error Description for the Code :401 Unimplemented statement or expression %ls.
SQL Server Error Code – 1827 create database or alter database failed
In this blog post, you’ll learn more about the SQL Server Error Code 1827 and the error message description that is shown SQL Server Error Code 1827 SQL Server Error Description for the Code :1827 CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of %I64d MB per %S_MSG.
SQL Server Error Code – 10042 cannot set any properties while there is
In this blog post, you’ll learn more about the SQL Server Error Code 10042 and the error message description that is shown SQL Server Error Code 10042 SQL Server Error Description for the Code :10042 Cannot set any properties while there is an open rowset.
SQL Server Error Code – 35498 external data source
In this blog post, you’ll learn more about the SQL Server Error Code 35498 and the error message description that is shown SQL Server Error Code 35498 SQL Server Error Description for the Code :35498 external data source
GOTO Label in SQL Server
There are times when you want to jump to a specific section (Label) in the code when a condition satisfies. You can create a label and then use the GOTO statement to branch directly to the code. To create a label , simply specify the label name followed by the colon. Label1: Here’s a query demonstrating the usage of the Label named “RecordExistsLabel” and GOTO…
SQL Server Error Code – 2786 the data type of substitution parameter
In this blog post, you’ll learn more about the SQL Server Error Code 2786 and the error message description that is shown SQL Server Error Code 2786 SQL Server Error Description for the Code :2786 The data type of substitution parameter %d does not match the expected type of the format specification.
SQL Server Error Code – 4137 a format file cannot be specified togeth
In this blog post, you’ll learn more about the SQL Server Error Code 4137 and the error message description that is shown SQL Server Error Code 4137 SQL Server Error Description for the Code :4137 A format file cannot be specified together with SINGLE_BLOB, SINGLE_CLOB or SINGLE_NCLOB option.
SQL Server Error Code – 6317 xquery: cannot update with value ‘%.*ls’
In this blog post, you’ll learn more about the SQL Server Error Code 6317 and the error message description that is shown SQL Server Error Code 6317 SQL Server Error Description for the Code :6317 XQuery: Cannot update with value ‘%.*ls’ because it failed validation against type ‘{%.*ls}%.*ls’