sql server error 11

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  March 24, 2011 at 10:18 am

  #389130

  We got an error SQL Server Alert System: 'SQL Server Error 11' occurred on \\sql2.

  011 is a specific database object is not found.

  A further investigation found an error in sql log: Input Parms do not match region table. I guess it’s some Stored procedure or user functions didn’t provide correct parameters.

  I can also find it is Spid 65, and the database name.

  But how can I find out what sproc or function that creates this error so that developer know how to fix it? We have 20 procedures there, so it's hard for them to debug it one by one.

  Where else or what more detailed information I can find to help them to locate it is which statement caused that error?

  Thanks