Tag: SQL Server Errors

SQL Server Error Msg 5509 – The properties SIZE or FILEGROWTH cannot be specified for the FILESTREAM data file ‘%.*ls’.

SQL Server Error Msg 20058 – The @agent_type must be 1 (Snapshot), 2 (Logreader), 3 (Distribution), or 4 (Merge)

SQL Server Error Msg 22993 – The Change Data Capture job table containing job information for database ‘%s’ cannot be found in the msdb system database. Run the stored procedure ‘sys.sp_cdc_add_job’ to create the appropriate CDC capture or cleanup job. The stored procedure will create the required job table.

SQL Server Error Msg 3988 – New transaction is not allowed because there are other threads running in the session.

SQL Server Error Msg 33105 – Cannot drop the database encryption key because it is currently in use. Database encryption needs to be turned off to be able to drop the database encryption key.

SQL Server Error Msg 40086 – Primary hit an error with this secondary.

SQL Server Error Msg 21086 – The retention period for the distribution database must be greater than the retention period of any existing non-merge publications.

SQL Server Error Msg 7936 – Table error: The FILESTREAM directory ID %.*ls exists for column ID %d of object ID %d, index ID %d, partition ID %I64d, but that column is not a FILESTREAM column.

SQL Server Error Msg 30106 – Invalid network security level.

SQL Server Error Msg 14719 – %s has not been granted permission to use proxy.

SQL Server Error Msg 29402 – Synchronous write task was aborted.

SQL Server Error Msg 40945 – The Table Auditing feature cannot be turned on for a server that contains Failover Groups. Please try Blob Auditing instead.

SQL Server Error Msg 19233 – A token from a cryptographic handshake was larger than allowed by SSPI.

SQL Server Error Msg 2285 – %sInvalid numeric entity reference

SQL Server Error Msg 1207 – Can’t allocate %u locks on startup, reverting to %u and turning on dynamic lock allocation.  Maximum allowed memory usage at startup is %I64u KB.

SQL Server Error Msg There are too many parameters in this %ls statement. The maximum number is %d. – 15

SQL Server Error Msg 45027 – %ls operation failed. Specified type information is not valid for federation distribution.

SQL Server Error Msg 8067 – The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter %d (“%.*ls”): Encryption type is not supported by this version of SQL Server.

SQL Server Error Msg 292 – There is insufficient result space to convert a smallmoney value to %ls.

SQL Server Error Msg 49817 – Failed to query CMS for thottling on database ‘%.*ls’, ‘%.*ls’ due to the exception: ‘%.*ls’