I have many stored procs in my database and I can call them just by
their name uspMyProc with success always. However, I just created a
user function ufnMyFunction as the same user that I created my procs
but when I call ufnMyFunction it fails unless I preface it with dbo. .
How come the stored proc does not require this but the stored function
does?

TFD