Christian Buettner-167247 (8/23/2011)

---

elbedata (8/23/2011)

---

It returns "that" when I test on SQL Server 2008, but I thought it should return "this"...

Has this changed in later SQL versions? I am pretty sure I've learned that prefixing SP:s with "sp_" was a bad idea and older MS documents clearly states this.

Lars B

Better check "Naming Stored Procedures", it perfectly explains what is happening.

(sp_one in master is not a system stored procedure, therefore it is not "preferred" over the one in the current database).

http://msdn.microsoft.com/en-us/library/ms190669.aspx