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.