tommyh (8/22/2011)
So BOL is wrong. From the linkIt is strongly recommended that you do not create any stored procedures using sp_ as a prefix. SQL Server always looks for a stored procedure beginning with sp_ in this order:
The stored procedure in the master database.
The stored procedure based on any qualifiers provided (database name or owner).
The stored procedure using dbo as the owner, if one is not specified.
Because running the example it most definatly runs the SP in the current database before the master database.
/T
I was tricked by BOL as well. Have they changed something and forgot to update documentation?
[EDIT] I wasn't paying too much attention... :ermm:
That's not a system store procedure so that was not the case.
Thank you for the question.
Best regards,
Best regards,
Andre Guerreiro Neto
Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA