Missing System Stored Procedures

I have a server that has a few system stored procedures missing, among them
sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
installation of a service pack. This server is going away in a couple of
weeks, but in the meatime, I would like to get put these system stored
procedures back, but have been unsuccessful doing so.
Does any have a suggestion, besides restoring master?Copy them from another SQL Server. Script them out and execute in the server
where they are missing.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"RogerT" <RogerT@.discussions.microsoft.com> wrote in message
news:2840B89F-C2FF-46D1-ACE3-F48CD2A9CF06@.microsoft.com...
>I have a server that has a few system stored procedures missing, among them
> sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
> installation of a service pack. This server is going away in a couple of
> weeks, but in the meatime, I would like to get put these system stored
> procedures back, but have been unsuccessful doing so.
> Does any have a suggestion, besides restoring master?|||What did you do to try to get the procedures back? Did you
try reapplying the latest Service Pack? If you had problems
with applying one of the service packs, you'd probably want
to make sure nothing else has been impacted.
-Sue
On Fri, 6 Oct 2006 15:40:02 -0700, RogerT
<RogerT@.discussions.microsoft.com> wrote:
>I have a server that has a few system stored procedures missing, among them
>sp_grantdbaccess, sp_droplogin, etc. I think this may be from a failed
>installation of a service pack. This server is going away in a couple of
>weeks, but in the meatime, I would like to get put these system stored
>procedures back, but have been unsuccessful doing so.
>Does any have a suggestion, besides restoring master?