could not find stored procedure ''

Question

Hi,

I have upgraded my SQL R2 to 2012.

Now, if I try anything on my publication (Even remove) I get the message "could not find stored procedure ''" (with just two quotes, no name).

What can be wrong?

Thanks

Bart

Answer 1

Are there any issues during the upgrade process?

Can you script out the creation process and check what step (proc) is causing the error message.

Answer 2

Please execute the below command and paste the O/P.

exec xp_msver

Go.

---

Regards JakDBA Please Mark this as Answered if this solves your issue or satisfied with the response.

Answer 3

@Bart

Please run this query to see if you have the SP stored anywhere in the db.

EXEC sp_msforeachdb '
select * from ?.information_schema.routines
where ''Person_info'' in (specific_name, routine_name)'

You may need to check who the actual owner of the stored procedure is. If it is a specific different user then that could be why you can't access it.

---

Best Regards,
Peja

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Answer 4

Index Name Internal_Value Character_Value
1 ProductName NULL Microsoft SQL Server
2 ProductVersion 720896 11.0.2100.60
3 Language 1033 English (United States)
4 Platform NULL NT x64
5 Comments NULL SQL
6 CompanyName NULL Microsoft Corporation
7 FileDescription NULL SQL Server Windows NT - 64 Bit
8 FileVersion NULL 2011.0110.2100.060 ((SQL11_RTM).120210-1917 )
9 InternalName NULL SQLSERVR
10 LegalCopyright NULL Microsoft Corp. All rights reserved.
11 LegalTrademarks NULL Microsoft SQL Server is a registered trademark of Microsoft Corporation.
12 OriginalFilename NULL SQLSERVR.EXE
13 PrivateBuild NULL NULL
14 SpecialBuild 137625660 NULL
15 WindowsVersion 498139398 6.1 (7601)
16 ProcessorCount 2 2
17 ProcessorActiveMask NULL                3
18 ProcessorType 8664 NULL
19 PhysicalMemory 4095 4095 (4294238208)
20 Product ID NULL NULL

Answer 5

Hi Peja, The sp name is an empty string.