sql server - Is it possible to call a user-defined function without the schema name? -

I am using MS SQL 2005 and when I make a function call me a schema to call it All my tables are also in the "dbo" schema and I do not need a schema name to give context to it:

  select dbo.MyFunc  

, So I want to know that I have some configuration unavailable which can do this for the function.

A short answer, no, it is not.

You should consider your database object to avoid having SQL Server to "see it" with all schema owner.

This makes your statements more readable and gives a slight increase in performance (although you probably will not report it).

Regards, Liven