SQL 2008 Upgrade

  • 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!

  • 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