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.
Sample:
[sql]
EXEC sp_helpsort ‘SQL_Latin1_General_Cp1_CS_AS_KI_WI’
[/sql]
Fix:
Remove parameters:
[sql]
EXEC sp_helpsort
[/sql]