September 10, 2012 at 8:43 am
So I`ve just moved an 3rd party application from SQL 2000 to SQL 2008 and a very specific piece of functionality is failing now. The application has a stored procedure name sp_AddUser. Unfortunately this is the name of a system sp and the application is generating an error of:
Procedure or function sp_adduser has too many arguments specified.
The procedure is executed from within compiled code so renaming the sp isn`t an option.
Can anyone recommend a fix from the DB side to resolve this......
Thanks!
September 10, 2012 at 12:08 pm
It is known that SQL Server will try to resolve anything with an "sp_" prefix as a system stored procedure first and if it cannot be resolved it will try in the user database. This results in a slight performance hit to any procedure prefixed with "sp_". The procedure would either have to be a different name or it would have to be fully qualified.
I'm actually surprised this wasn't giving you an issue beforehand. With that said, there IS a work around.
This post has more information http://www.sqlservercentral.com/Forums/Topic8041-65-1.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply