Re: SP_ in Stored Procedure Name
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 05/19/04
- Next message: Hari: "Re: Please Help"
- Previous message: Bhavtosh: "Copying the BD Diagram from SQL to MS Word"
- In reply to: Prabhat: "SP_ in Stored Procedure Name"
- Next in thread: Wayne Snyder: "Re: SP_ in Stored Procedure Name"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 19 May 2004 15:54:26 +0530
Hi,
Yes.
All the procedures started with SP_ will be treated as system stored
procedures and will be kept in Master database. Those procedures with SP_ in
Master database can be accessed from any database with out giving any
identifiers (dbname..procedure_name). So when every we create a procedure
with name SP_ in any user database while execution it checks for the same SP
in Master database and if it is not available then it fires the procedure
available in local user database.
Thanks
Hari
MCDBA
"Prabhat" <not_a_mail@hotmail.com> wrote in message
news:OptyhhYPEHA.1512@TK2MSFTNGP10.phx.gbl...
> Resending the Post Again as After one day of Posting It did not appear in
> newsgroup.
>
> Hi All,
>
> I have one doubt. If I have given my Stored Procedure name begin with the
> name "SP_" then when I Try to execute the Stored Procedure then Will the
SQL
> Server will serach for that Stored Procedure first in MASTER database and
> then the Current Database?
>
> If That is the case. Then Why SQl Server search for the Stored procedure
in
> Master first?
>
> Thanks
> Prabhat
>
>
>
- Next message: Hari: "Re: Please Help"
- Previous message: Bhavtosh: "Copying the BD Diagram from SQL to MS Word"
- In reply to: Prabhat: "SP_ in Stored Procedure Name"
- Next in thread: Wayne Snyder: "Re: SP_ in Stored Procedure Name"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
