procedure has no parameters and arguments were supplied sql server

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

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:
[sql]
EXEC sp_helpsort ‘SQL_Latin1_General_Cp1_CS_AS_KI_WI’
[/sql]

Fix:

Remove parameters:
[sql]
EXEC sp_helpsort
[/sql]




Reference : Devi Prasad (sqlserverlearner.com)

Do you like my blog?

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



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.




Your Ad Here


Tags: , , ,