// SQL Server error reference

SQL Server error 8146: Procedure has no parameters

Arguments were passed to a stored procedure that takes none. The caller and the deployed procedure don't agree on its definition.

Error number
8146
Severity
16
Category
Names and objects
Error message
Procedure %.*ls has no parameters and arguments were supplied.

What it means

A procedure declared without parameters can't accept any arguments. Passing one raises 8146, which usually means the procedure in this database is an older or different version than the caller expects.

Common causes

  • Parameters were added to the procedure in development but not deployed here.
  • A procedure with the same name but no parameters exists in the schema being resolved.

How to fix it

  1. Check the definition that is deployed.

    EXEC sp_helptext 'dbo.RefreshCache';
  2. Deploy the version with parameters, or call it without arguments.

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.