Category: SQL Server
SQL Server Error Code – 15123 the configuration option ‘%s’ does not e
In this blog post, you’ll learn more about the SQL Server Error Code 15123 and the error message description that is shown SQL Server Error Code 15123 SQL Server Error Description for the Code :15123 The configuration option ‘%s’ does not exist, or it may be an advanced option.
SQL Server Error Code – 40110 cannot scope database %s for sp_cloud_sc
In this blog post, you’ll learn more about the SQL Server Error Code 40110 and the error message description that is shown SQL Server Error Code 40110 SQL Server Error Description for the Code :40110 Cannot scope database %s for sp_cloud_scope_database spec proc because it is already set up as a partition database.
How to get the date part from the date time in SQL Server ?
If you are on SQL Server 2008 and higher version and want to get the date part of the datetime data in SQL Server , you can use the CONVERT method as shown in this post. How to get the date part from the date time in SQL Server ? If you want to get the current date leaving out the time from the datetime…
SQL Server Error Code – 1799 column ?%.*ls? cannot be used to federat
In this blog post, you’ll learn more about the SQL Server Error Code 1799 and the error message description that is shown SQL Server Error Code 1799 SQL Server Error Description for the Code :1799 Column ?%.*ls? cannot be used to federate the table ?%.*ls? because it does not match the federation key type.
SQL Server Error Code – 4008 the data types varchar(max), nvarchar(ma
In this blog post, you’ll learn more about the SQL Server Error Code 4008 and the error message description that is shown SQL Server Error Code 4008 SQL Server Error Description for the Code :4008 The data types varchar(max), nvarchar(max), varbinary(max), and XML cannot be used in the compute clause by client driver versions earlier than SQL Server 2005. Please resubmit the query using a…
SQL Server Error Code – 12025 could not find required binary spatial m
In this blog post, you’ll learn more about the SQL Server Error Code 12025 and the error message description that is shown SQL Server Error Code 12025 SQL Server Error Description for the Code :12025 Could not find required binary spatial method in a condition
SQL Server Error Code – 13297 encryption algorithm tag
In this blog post, you’ll learn more about the SQL Server Error Code 13297 and the error message description that is shown SQL Server Error Code 13297 SQL Server Error Description for the Code :13297 encryption algorithm tag
SQL Server Error Code – 917 an upgrade script batch failed to execut
In this blog post, you’ll learn more about the SQL Server Error Code 917 and the error message description that is shown SQL Server Error Code 917 SQL Server Error Description for the Code :917 An upgrade script batch failed to execute for database ?%.*ls? due to compilation error. Check the previous error message for the line which caused compilation to fail.
SQL Server Error Code – 1963 cannot create %s_msg on view ?%.*ls?. th
In this blog post, you’ll learn more about the SQL Server Error Code 1963 and the error message description that is shown SQL Server Error Code 1963 SQL Server Error Description for the Code :1963 Cannot create %S_MSG on view ?%.*ls?. The view contains a convert that is imprecise or non-deterministic.
SQL Server Error Code – 13166 conversation group
In this blog post, you’ll learn more about the SQL Server Error Code 13166 and the error message description that is shown SQL Server Error Code 13166 SQL Server Error Description for the Code :13166 conversation group
SQL Server Error Code – 14364 the tsx server is not currently enlisted
In this blog post, you’ll learn more about the SQL Server Error Code 14364 and the error message description that is shown SQL Server Error Code 14364 SQL Server Error Description for the Code :14364 The TSX server is not currently enlisted
SQL Server Error Code – 20673 a value for the parameter @host_name was
In this blog post, you’ll learn more about the SQL Server Error Code 20673 and the error message description that is shown SQL Server Error Code 20673 SQL Server Error Description for the Code :20673 A value for the parameter @host_name was specified, but no articles in the publication use SUSER_SNAME() for parameterized filtering.
SQL Server Error Code – 22803 change data capture has scanned the log
In this blog post, you’ll learn more about the SQL Server Error Code 22803 and the error message description that is shown SQL Server Error Code 22803 SQL Server Error Description for the Code :22803 Change Data Capture has scanned the log from LSN{%s} to LSN{%s}, %d transactions with %d commands have been extracted. To report on the progress of the operation, query the sys.dm_cdc_log_scan_sessions…
SQL Server Error Code – 21040 publication ‘%s’ does not exist.
In this blog post, you’ll learn more about the SQL Server Error Code 21040 and the error message description that is shown SQL Server Error Code 21040 SQL Server Error Description for the Code :21040 Publication ‘%s’ does not exist.
SQL Server Error Code – 39096 execution failed because its with clause
In this blog post, you’ll learn more about the SQL Server Error Code 39096 and the error message description that is shown SQL Server Error Code 39096 SQL Server Error Description for the Code :39096 Execution failed because its WITH clause specified different output columns from what ‘PREDICT’ function tries to return. The schema returned by ‘PREDICT’ function is ‘%ls’.
SQL Server Error Code – 4442 union all view ‘%.*ls’ is not updatable
In this blog post, you’ll learn more about the SQL Server Error Code 4442 and the error message description that is shown SQL Server Error Code 4442 SQL Server Error Description for the Code :4442 UNION ALL view ‘%.*ls’ is not updatable because base table ‘%.*ls’ is used multiple times.
SQL Server Error Code – 6873 redefinition of ‘xsi’ xml namespace pref
In this blog post, you’ll learn more about the SQL Server Error Code 6873 and the error message description that is shown SQL Server Error Code 6873 SQL Server Error Description for the Code :6873 Redefinition of ‘xsi’ XML namespace prefix is not supported with ELEMENTS XSINIL option of FOR XML.
SQL Server Error Code – 8189 you do not have permission to run ‘%ls’.
In this blog post, you’ll learn more about the SQL Server Error Code 8189 and the error message description that is shown SQL Server Error Code 8189 SQL Server Error Description for the Code :8189 You do not have permission to run ‘%ls’.
SQL Server Error Code – 9721 service broker failed to clean up conver
In this blog post, you’ll learn more about the SQL Server Error Code 9721 and the error message description that is shown SQL Server Error Code 9721 SQL Server Error Description for the Code :9721 Service broker failed to clean up conversation endpoints on database ‘%.*ls’. Another problem is preventing SQL Server from completing this operation. Check the SQL Server error log for additional messages.
SQL Server Error Code – 12834 the database ‘%.*ls’ could not be create
In this blog post, you’ll learn more about the SQL Server Error Code 12834 and the error message description that is shown SQL Server Error Code 12834 SQL Server Error Description for the Code :12834 The database ‘%.*ls’ could not be created or altered to a contained database, because the computed column ‘%.*ls’ on %S_MSG ‘%.*ls’ depends on builtin function ‘%s’. In a contained database,…