SQLServerCentral.com / SQL Server 2012 / SQL 2012 - General / ErrorLog Found in sql server 2012 / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 11:02:11 GMT20RE: ErrorLog Found in sql server 2012http://www.sqlservercentral.com/Forums/Topic1435294-2799-1.aspxThis apparently been fixed in SQL 2012 SP1 CU4.FIX: Error 1222 when you use Service Broker in SQL Server 2012 http://support.microsoft.com/kb/2837910Fri, 21 Mar 2014 13:27:09 GMTpreston.vanderplaatsRE: ErrorLog Found in sql server 2012http://www.sqlservercentral.com/Forums/Topic1435294-2799-1.aspxThere is no permanent solution as such at database server level.As per the above link:[i]Implementing an error handler that traps error message 1222 allows an application to handle the time-out situation and take remedial action, such as: automatically resubmitting the statement that was blocked or rolling back the entire transaction.[/i]Its not recommended to change the LOCK_TIMEOUT value at server level.You can try to change it for a specific connection or transaction submitted.Wed, 27 Mar 2013 04:29:31 GMTKumari PunamRE: ErrorLog Found in sql server 2012http://www.sqlservercentral.com/Forums/Topic1435294-2799-1.aspxIs there a permanent solution to prevent time out expired.Tue, 26 Mar 2013 08:26:57 GMTvishalsurya50RE: ErrorLog Found in sql server 2012http://www.sqlservercentral.com/Forums/Topic1435294-2799-1.aspx[url]http://msdn.microsoft.com/en-IN/library/ms177413%28v=sql.105%29.aspx[/url]details can be found hereTue, 26 Mar 2013 02:08:51 GMTJayanth_KurupErrorLog Found in sql server 2012http://www.sqlservercentral.com/Forums/Topic1435294-2799-1.aspxHi , I found the below error in my error log in sql server 2012 . Kindly advice. Error: ----- An error occurred in Service Broker internal activation while trying to scan the user queue 'msdb.dbo.InternalMailQueue' for its status. Error: 1222, State: 51. Lock request time out period exceeded. This is an informational message only. No user action is Can anyone let me the impact of this as it is an production server. Kindly let me know it ASAP. RegardsVishalTue, 26 Mar 2013 01:42:32 GMTvishalsurya50