procedure has no parameters and arguments were supplied sql server

Posted on : 23-04-2012 | By : Devi Prasad | In : SQL Errors

Share:

0


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:

EXEC sp_helpsort 'SQL_Latin1_General_Cp1_CS_AS_KI_WI'

Fix:

Remove parameters:

EXEC sp_helpsort
(Visited 340 times, 1 visits today)



References : Devi Prasad (sqlserverlearner.com)

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.


Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.




Write a comment



Tags: , , ,