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
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
-
Check the definition that is deployed.
EXEC sp_helptext 'dbo.RefreshCache';
-
Deploy the version with parameters, or call it without arguments.
Related errors
More names and objects errors
208Invalid object name207Invalid column name4104Multi-part identifier not bound209Ambiguous column name2812Could not find stored procedure2714There is already an object named3701Cannot drop, object not found3702Cannot drop database, currently in use
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.