Issue:
Why am I receiving the error message, “[Microsoft][SQL Native Client][SQL Server]Procedure or function spSmartFill has too many arguments specified.”?
Resolution:
This issue was resolved in the latest builds of SmartFill. Upgrade to the latest build of SmartFill, or edit the spSmartFill.sql stored procedure file for each of your company databases as follows:
Here’s what the top part of the stored procedure may look like now:
CREATE PROC spSmartFill
@SmartFillObjectID INT,
@UserID CHAR(15),
@CompanyID INT,
@SearchValue CHAR(50)
AS
DECLARE @SmartFillObjectName CHAR(50)
Make the following changes (changed lines are in bold):
CREATE PROC spSmartFill
@SmartFillObjectID INT,
@UserID CHAR(15),
@CompanyID INT,
@SearchValue CHAR(50),
@SearchValue2 CHAR(50),
@SearchValue3 CHAR(50),
@SearchValue4 CHAR(50),
@SearchValue5 CHAR(50),
@SearchValue6 CHAR(50),
@SearchValue7 CHAR(50),
@SearchValue8 CHAR(50),
@SearchValue9 CHAR(50)
AS
DECLARE @SmartFillObjectName CHAR(50)