SQL Server Errors or Failures from Error: 11531 to Error: 11551

You may receive various errors in SQL Server while working. Below are some of the SQL Server Errors from Error: 11531 to Error: 11551
Error: 11531, Severity: 16, The object id ‘%d’ passed to sys.dm_exec_describe_first_result_set_for_object refers to an object which is not a T-SQL procedure or trigger.
Error: 11532, Severity: 16, The object id ‘%d’ passed to sys.dm_exec_describe_first_result_set_for_object was invalid.
Error: 11533, Severity: 16, Type ‘%.*ls’ is not a valid object name for result set definition.
Error: 11534, Severity: 16, Type ‘%.*ls’ is invalid or not a table type.
Error: 11535, Severity: 16, EXECUTE statement failed because its WITH RESULT SETS clause specified %d result set(s), and the statement tried to send more result sets than this.
Error: 11536, Severity: 16, EXECUTE statement failed because its WITH RESULT SETS clause specified %d result set(s), but the statement only sent %d result set(s) at run time.
Error: 11537, Severity: 16, EXECUTE statement failed because its WITH RESULT SETS clause specified %d column(s) for result set number %d, but the statement sent %d column(s) at run time.
Error: 11538, Severity: 16, EXECUTE statement failed because its WITH RESULT SETS clause specified type ‘%ls’ for column #%d in result set #%d, and the corresponding type sent at run time was ‘%ls’; there is no conversion between the two types.
Error: 11539, Severity: 16, One of the types specified in WITH RESULT SETS clause has been modified after the EXECUTE statement started running. Please rerun the statement.
Error: 11541, Severity: 16, sp_describe_first_result_set cannot be invoked when SET STATISTICS XML or SET STATISTICS PROFILE is on.
Error: 11542, Severity: 16, sp_describe_undeclared_parameters failed to discover parameter metadata for remote procedure call because parameters were passed by name and by name parameter metadata discovery failed.
Error: 11543, Severity: 16, SET STATISTICS XML ON and SET STATISTICS PROFILE ON are not allowed inside any procedure or batch that executes through an EXECUTE statement that has a WITH RESULT SETS clause.
Error: 11544, Severity: 16, Could not deduce type for parameter in position ‘%d’ for remote call to module ‘%.*ls’.
Error: 11545, Severity: 16, Remote result set discovery cannot be done inside SELECT INTO.
Error: 11546, Severity: 16, sp_showmemo_xml cannot run when the STATISTICS XML, STATISTICS PROFILE or SHOWPLAN set option is on. Set these options to OFF and re-run sp_showmemo_xml.
Error: 11547, Severity: 16, Only one statement can be used as input parameter to sp_showmemo_xml. Modify the input parameter and re-run the stored procedure.
Error: 11548, Severity: 16, The stored procedure ‘sp_showmemo_xml’ is not available in this edition of SQL Server.
Error: 11549, Severity: 16, Using stored procedures is not supported. Modify the input parameter and re-run sp_showmemo_xml.
Error: 11550, Severity: 16, The metadata could not be determined because remote metadata discovery failed for statement ‘%.*ls’.
Error: 11551, Severity: 16, The metadata could not be determined because remote metadata discovery failed for statement ‘%.*ls’ in procedure ‘%.*ls’.
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.
Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.