Todas las respuestas
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.
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