Microsoft KB Archive/221148

= PRB: SQL 7.0 Upgrade Fails w/ 'Could not find stored procedure' Msg =

Article ID: 221148

Article Last Modified on 3/27/1999

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q221148



SYMPTOMS
The upgrade from SQL Server 6.5 to 7.0 fails while importing the replication setting with the following error reported in the Import Replication Settings.err file:

Microsoft SQL-DMO (ODBC SQLState: 42000) returned error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure ''.



CAUSE
This error is caused by improper distributor settings in SQL Server 6.5 for a publisher.

In SQL Server 6.5, each publisher server must have a distribution server defined in sysservers. This setting is imported into SQL Server 7.0 to determine which distribution database to use on SQL Server 7.0. If the distributor is not defined properly on SQL Server 6.5, the distribution server value becomes NULL.

With default ANSI settings for SQL Server 7.0, the stored procedure name concatenated to a NULL distribution server name yields NULL and the error occurs.



WORKAROUND
Determine the distribution server in SQL Server 6.5 by running sp_helpdistributor. If this does not return the proper value, fix the distribution server setting using the SQL Enterprise Manager by selecting Server, Replication Configuration, Publishing.

Additional query words: distribution server

Keywords: kbprb KB221148

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.