MSSQL Stored Procedure prefix SP_

Discussion in 'Databases' started by pgiddy, Dec 15, 2008.

0
  1. #1
    Apparently if a stored procedure's name begins with "SP_", SQL Server first looks in the master database.

    Does anyone know if this also holds true for the prefix "sp" (without the underscore?

    Thanks
     
    pgiddy, Dec 15, 2008 IP
  2. rajib.bahar

    rajib.bahar Active Member

    Messages:
    87
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    68
    #2
    I don't know about the sp without underscore... However, If you fully qualify it then it shouldn't matter how you prefix the name.

    By fully qualifying I mean something like DatabaseName.TableName.Object name... For example, Northwind.dbo.spGetEmployees

    I think this will partially address your question...
     
    rajib.bahar, Dec 18, 2008 IP