Error 208 when updating any Stored Procedure

Hey all,
I can't update any stored procedure in my database, even as an
admin. I get:
Error 208: Invalid object name 'storedprocedurename'
Any suggestions? I've done a search on the MS knowledgebase and
google but no luck. The user can't do it and myself as an admin can't
either.
The workaround right now is to drop the proc and re-create it with the
changes.who is the owner of the sp?
"Dave" <shoad316@.hotmail.com> wrote in message
news:78cf0572.0401131336.5d46a539@.posting.google.com...

quote:

---

> Hey all,
> I can't update any stored procedure in my database, even as an
> admin. I get:
> Error 208: Invalid object name 'storedprocedurename'
> Any suggestions? I've done a search on the MS knowledgebase and
> google but no luck. The user can't do it and myself as an admin can't
> either.
> The workaround right now is to drop the proc and re-create it with the
> changes.

---

|||A user is the db_owner and its the same account trying to do the update.
Thanks
--
david.best@.sympatico.ca
"Thanks to the remote control I have the attention span of a gerbil!"
"There are 10 types of people in the world. Those who understand binary,
and those who don't."
"NEW NAME, OLD GUY" <PLEASE!> wrote in message
news:OJF58Ui2DHA.2208@.TK2MSFTNGP12.phx.gbl...

quote:

---

> who is the owner of the sp?
> "Dave" <shoad316@.hotmail.com> wrote in message
> news:78cf0572.0401131336.5d46a539@.posting.google.com...
>

---

|||probably this should help
ALTER PROC owner_name.PROC_NAME
................
replace owner_name with the correct owner name.
"Dave Best" <david.bestNOSPAM@.sympatico.ca> wrote in message
news:RT0Nb.10886$881.1646973@.news20.bellglobal.com...

quote:

---

> A user is the db_owner and its the same account trying to do the update.
> Thanks
> --
> --
> david.best@.sympatico.ca
> "Thanks to the remote control I have the attention span of a gerbil!"
> "There are 10 types of people in the world. Those who understand binary,
> and those who don't."
> "NEW NAME, OLD GUY" <PLEASE!> wrote in message
> news:OJF58Ui2DHA.2208@.TK2MSFTNGP12.phx.gbl...
>

---