Re: Stored Procedure

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 18:05:23 +0100

Hi

It will, I don't know when/why/how that feature was decided, but it would
mean that system procedures can be found quicker. Procedures not starting
with sp_ will be searched for in the current database first.
John

"Prabhat" <not_a_mail@hotmail.com> wrote in message
news:ubOoyaPPEHA.2452@TK2MSFTNGP11.phx.gbl...
> 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
>
>

Relevant Pages

  • Re: Trigger, alternative way to pass variable to trigger
    ... You don't have to execute the setUser command in the master database, ... create trigger trigger name ... to call stored procedure or execute sql commands and let it handle it the ... Pro SQL Server 2000 Database Design ...
    (microsoft.public.sqlserver.programming)
  • SP_ in Stored Procedure Name
    ... 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 Why SQl Server search for the Stored procedure in ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored Procedure
    ... System stored procedures are created and stored in the master ... database and have the sp_ prefix. ... from any database without having to qualify the stored procedure name fully ... The stored procedure in the master database. ...
    (microsoft.public.sqlserver.programming)
  • Giving access to outside web site to SQL Server stored procedure
    ... I have a sql server 2000 production database that will need to have ... database and one stored procedure that they can see the master database. ...
    (microsoft.public.sqlserver.security)
  • Stored Procedure
    ... 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 Why SQl Server search for the Stored procedure in ...
    (microsoft.public.sqlserver.programming)