SQL Server error 8144: Too many arguments specified
A call passed more arguments than the procedure or function defines, often because the code and the deployed procedure are different versions.
- Error number
8144- Severity
- 16
- Category
- Names and objects
What it means
SQL Server matches arguments to the parameters a procedure or function declares. If a call supplies more values than there are parameters, it fails with 8144. It usually means the caller expects a newer (or older) version of the procedure than the one in the database.
Common causes
- The application was updated to pass a new parameter, but the procedure change wasn't deployed to this database.
- Calling a procedure with the same name in a different schema or database that has fewer parameters.
- An extra comma-separated value in a hand-written
EXECcall.
How to fix it
-
Check the parameters the procedure actually has.
SELECT name, TYPE_NAME(user_type_id) AS type_name, is_output FROM sys.parameters WHERE object_id = OBJECT_ID(N'dbo.SaveOrder') ORDER BY parameter_id;
-
Deploy the matching version of the procedure, or remove the extra arguments from the call.
EXEC dbo.SaveOrder @CustomerId = 42, @Total = 99.50;
-
Name arguments in calls (
@Param = value), which makes mismatches obvious.
Related errors
8145Is not a parameter for procedure8146Procedure has no parameters2812Could not find stored procedure42883PostgreSQL: function does not exist1318MySQL: Incorrect number of arguments
More names and objects errors
208Invalid object name207Invalid column name4104Multi-part identifier not bound209Ambiguous column name2714There is already an object named3701Cannot drop, object not found3702Cannot drop database, currently in use5030Database couldn't be exclusively locked
The code and message text are from the Microsoft Database Engine events and errors reference. Browse the full SQL Server error list or search every database error.
Work on SQL Server in SQLly
A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for SQL Server and the other databases you use.