Re: using 'sp_' as a naming convention for stored procedures

From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 03/15/04 

Date: Sun, 14 Mar 2004 23:45:45 -0500

> it. The DBA group told me that when using "sp_" as a
> name for a stored procedure it automatically causes the
> call to go to the master DB to look it up. I have never
> heard of this before.
>
> Has anyone else?

Yes, and they weren't making it up. Books Online even has this information. 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

Relevant Pages

  • Re: stored procedure corrupted
    ... Aaron Bertrand ... SQL Server MVP ... "khanhbui" wrote in message ... > stored procedure was not scripted it is possible that information in ...
    (microsoft.public.sqlserver.server)
  • Re: stored procedure corrupted
    ... I was going on "message like stored procedure was not scripted" which ... > If we encrypt we are supposed to get an error like "The object comments ... >> Aaron Bertrand ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Incorrect Query Results w/ Wildcard
    ... > Stored Procedure: ... Is there something goofy about using ... >>Aaron Bertrand ... >>SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Unable to find stored procedure sp_tables
    ... SQL Server MVP ... > The stored procedure 'sp_tables' does exist in the master database. ...
    (microsoft.public.sqlserver.security)
  • Re: Copying Table Structure
    ... Aaron Bertrand ... SQL Server MVP ... "Joe" wrote in message ... > know of a stored procedure or command that will copy the table structure ...
    (microsoft.public.sqlserver.programming)
Loading