I need help with SQL Server Error 8144

[jcmercure]

Hello -

I am not a SQL Server programmer and Microsoft's site was not helpful.

I am working on a VB project that is using SQL Server 2000 as the backend. The database is accessed via Business and Database COM+ objects.

I have a class with a method that executes a Stored Procedure. When I attempted execute the stored procedure a SQL Server error is returned. The error is '8144' and the message reads "Procedure or function oms_ext_con_auto_create has too many arguments specified". When I compare the values being passed to the procedure with the procedure requirements, everything appears in order. The number of parameters passed matches the definition.

Does this error indicate a problem on the SQL Server side or a problem with the call to SQL Server?

Thank you in advance for any help I receive.

- John Mercure

 

[SonOfEmidec1100]

That error definitely occurs when you are passing more parameters than the sp expects, so the error could be either side.

Can you post the part of the sp up to AS and the calling code.