When you try to pass arguments to stored procedure which do not have parameters you get the below error:

Msg 8146, Level 16, State 1, Procedure sp_helpsort, Line 0
Procedure sp_helpsort has no parameters and arguments were supplied.

EXEC sp_helpsort ‘SQL_Latin1_General_Cp1_CS_AS_KI_WI’


Remove parameters:
EXEC sp_helpsort

Leave a Reply

Your email address will not be published. Required fields are marked *