text: , can you update anything else in the database? Is it possible that the procedure is in a different namespace? e.g. myname.spMyProcedure instead of dbo.spMyProcedure
  Open in new window
  when ALTER or RUN your SP.
  Hopei it helps...
  This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.
  in which database your required (Corrected Useful ) Stored Procedure residing then
  then you can recognize them then either you want to EDIT or DROP them
  SELECT name, create_date, modify_date
  FROM sys.objects
  WHERE type = 'P'
  AND name = 'your Stored Procedure name'
  Let's say you are searching for 'foobar' in all your stored procedures. You can do this using the INFORMATION_SCHEMA.ROUTINE
  SELECT ROUTINE_NAME, ROUTINE_DEFINITION
  FROM INFORMATION_SCHEMA.ROUTINE
  WHERE ROUTINE_DEFINITION LIKE '%foobar%'
  AND ROUTINE_TYPE='PROCEDURE'
  Experts Exchange Solution brought to you by
  Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.Start your 7-day free trial
  Thanks