Saturday, April 28, 2012 6:14 AM
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?
Sunday, April 29, 2012 5:18 PM
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.
Sunday, April 29, 2012 10:02 PM
Please execute the below command and paste the O/P.
Regards JakDBA Please Mark this as Answered if this solves your issue or satisfied with the response.
Monday, April 30, 2012 8:00 AMModerator
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.
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.
Monday, May 07, 2012 4:29 PMIndex 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
Monday, May 07, 2012 4:30 PMHi Peja, The sp name is an empty string.