Re:create a global procedure

Tech-Archive recommends: Speed Up your PC by fixing your registry

anonymous_at_discussions.microsoft.com
Date: 03/19/04 

Date: Fri, 19 Mar 2004 07:42:58 -0800

name your procedure beginning with sp
>-----Original Message-----
>How do i create a procedure in master db which can be
recognized in every
>other dbs.
>
>For instance, sp_help is a system procedure that exists
in master db.
>but you can run this procedure in any other dbs as well.
>How can I create such a global procedure?
>
>
>
>
>
>
>
>
>
>.
>

Relevant Pages

  • RE: msdb
    ... Nun weis ich wie ich weiterfahren kann, ... Als Notlösung musste ich eine anderen Server nehmen, für die Produktive DBs. ... dass auch die Master DB Fehler aufweist. ...
    (microsoft.public.de.sqlserver)
  • create a global procedure
    ... sp_help is a system procedure that exists in master db. ... but you can run this procedure in any other dbs as well. ... How can I create such a global procedure? ...
    (microsoft.public.sqlserver.programming)
  • Re: create a global procedure
    ... Put it in master, make sure it is owned by dbo and have the name of the ... I do not recommend doing this for other than system programming things (not ... > but you can run this procedure in any other dbs as well. ...
    (microsoft.public.sqlserver.programming)
  • Re: create a global procedure
    ... Create it in master, call it sp_whatever ... ... sp_help is a system procedure that exists in master db. ... > but you can run this procedure in any other dbs as well. ... > How can I create such a global procedure? ...
    (microsoft.public.sqlserver.programming)