SQL Server Errors or Failures from Error: 40187 to Error: 40302
Error: 40187, Severity: 16, The metadata record for the partition does not exist.
Error: 40192, Severity: 16, Catchup of secondary at %s:%s:%s:%d has been cancelled.
Error: 40193, Severity: 16, The maximum allowed number of database is already paired.
Error: 40194, Severity: 16, Table %s has a partition key already. Explicitly specifying a new partition key is not allowed. Please use “Alter table”.
Error: 40195, Severity: 16, %ls FOR SID command is not supported in this version of SQL Server.
Error: 40196, Severity: 16, A varbinary can not be longer than max length specified.
Error: 40197, Severity: 16, The service has encountered an error processing your request. Please try again. Error code %d.
Error: 40198, Severity: 16, Only a primary replica can be configured as a forwarder.
Error: 40199, Severity: 16, There should be no context transaction when entering the forwarder pending state.
Error: 40201, Severity: 16, Destination server name is too long.
Error: 40202, Severity: 16, Corrupted composite message.
Error: 40203, Severity: 16, Could not register AsyncTransport endpoint.
Error: 40204, Severity: 16, Dispatch sequence number maintenance failure
Error: 40205, Severity: 16, Maximum transport queue size reached.
Error: 40206, Severity: 16, Heartbeat lease time is less than the heartbeat worker interval.
Error: 40207, Severity: 16, Async transport test failed.
Error: 40208, Severity: 16, Corrupted received message format.
Error: 40209, Severity: 17, Duplicate destination id.
Error: 40301, Severity: 16, Invalid lock mode or resource received in lock request.
Error: 40302, Severity: 16, Invalid identity value.
This is applicable on below versions of SQL Server
SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
Hope this was helpful.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.