Re: Edit System Stored Procedure, i.e. sp_helpdb

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: David G. (david_nospam_at_nospam.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 13:11:09 -0400

NRS wrote:
> That's one of the solutions, but not for my problem, because I need
> to call it sp_helpdb, I have one call from one application to that
> stored procedure that needs to be changed. So if I create a new one
> with my modifications it won't work because i don't have the source
> code of the apllication to change the call to the stored procedure.
>
> Thanks,
> NRS
>
> "Geoff N. Hiten" wrote:
>
>> Copy the code and call it sp_MYHelpDB. Make changes to that one.
>>
>> --
>> Geoff N. Hiten
>> Microsoft SQL Server MVP
>> Senior Database Administrator
>> Careerbuilder.com
>>
>> I support the Professional Association for SQL Server
>> www.sqlpass.org
>>
>> "NRS" <NRS@discussions.microsoft.com> wrote in message
>> news:F946A230-8217-4C22-B4F5-E37BCDE0A393@microsoft.com...
>>> Hi,
>>> Let's imagine I need to change something in sp_helpdb, how can I do
>>> it? If I right click in SP and choose properties the code is non
>>> editable. If i try to make an alter SP in Query Analyzer I get a
>>> lot of errors.
>>> Any one know how to do it?
>>> Thanks in advance,
>>> NRS

What about creating a sp_helpdb owned by the user the application is
running under and in the database the application is connected to. If
this is a unique user, it shouldn't interfere with anyone else and
wouldn't require changes to the system proc.

I assume you can run this application (that has no source) using a login
of your choosing? 

-- 
David G.

Relevant Pages