Tag: SQL Server Errors

SQL Server Error Msg 10136 – Cannot create %S_MSG on view “%.*ls” because it uses the aggregate COUNT. Use COUNT_BIG instead.

SQL Server Error Msg 1428 – The request is refused because the responding server instance is not in a state to service the request.

SQL Server Error Msg 11263 – A corrupted message has been received. The service pair security header size is %d, however it must be between %d and %d bytes. This occurred in the message with Conversation ID ‘%.*ls’, Initiator: %d, and Message sequence number: %I64d.

SQL Server Error Msg 27176 – The parameter ‘%ls’ does not exist or you do not have sufficient permissions.

SQL Server Error Msg 4215 – The log was not truncated because records at the beginning of the log are pending replication or Change Data Capture. Ensure the Log Reader Agent or capture job is running or use sp_repldone to mark transactions as distributed or captured.

SQL Server Error Msg 9904 – The full-text catalog ‘%ls’ (%d) in database ‘%ls’ (%d) will be remounted to recover from a failure. Reason code: %d. Error: %ls. If this message occurs frequently, consult SQL Server Books Online for troubleshooting assistance. This is an informational message only. No user action is required.

SQL Server Error Msg 9952 – Informational: Full-text auto change tracking is turned off for table or indexed view ‘%ls’ (table or indexed view ID ‘%d’, database ID ‘%d’) due to fatal crawl error.

SQL Server Error Msg 2525 – Database file %.*ls is offline.

SQL Server Error Msg 2747 – Too many substitution parameters for RAISERROR. Cannot exceed %d substitution parameters.

SQL Server Error Msg 10027 – Command was not prepared.

SQL Server Error Msg 13605 – Column expressions and data sources without names or aliases cannot be formatted as JSON text using FOR JSON clause. Add alias to the unnamed column or table.

SQL Server Error Msg 16 – 417

SQL Server Error Msg 20731 – This edition of SQL Server does not support publications. Dropping existing publications.

SQL Server Error Msg 18395 – Reason: Authentication was successful, but database was not found on this logical server.

SQL Server Error Msg 12117 – Cannot free the plan because a plan was not found in the database plan cache that corresponds to the specified plan handle. Specify a cached plan handle for the database. For a list of cached plan handles, query the sys.dm_exec_query_stats dynamic management view.

SQL Server Error Msg lock – 0

SQL Server Error Msg 7971 – SPID (server process ID): %d%s

SQL Server Error Msg 30070 – During the database upgrade, the full-text word-breaker component ‘%ls’ that is used by catalog ‘%ls’ was successfully verified. Component version is ‘%ls’. Full path is ‘%.*ls’. Language requested is %d. Language used is %d.

SQL Server Error Msg 2299 – %sRequired attribute “%ls” of XSD element “%ls” is missing.

SQL Server Error Msg 21221 – The specified source object must be a view object if it is going to be as a ‘view schema only’ type article.