// SQL Server error reference

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
Error message
Procedure or function %.*ls has too many arguments specified.

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 EXEC call.

How to fix it

  1. 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;
  2. Deploy the matching version of the procedure, or remove the extra arguments from the call.

    EXEC dbo.SaveOrder @CustomerId = 42, @Total = 99.50;
  3. Name arguments in calls (@Param = value), which makes mismatches obvious.

Related errors

More names and objects errors

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.

// fewer errors, faster fixes

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.