Category: SQL Server

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 – 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 – 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 – 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 – 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 – 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,…