title: User-defined function in master database won't execute
body: <p>I have this function called <code>fn_blah</code> that resides in the <code>Master</code> database of a SQL Server 2000 box. The same function resides in the <code>master</code> database of a SQL Server 2008 box. On the SQL Server 2000 box, the function runs just fine under a different database context without specifying the owner (eg. dbo):</p>
  
  <pre><code>User OtherDB1;
  EXEC fn_blah;
  </code></pre>
  
  <p>But on the SQL Server 2008 box, the above query won't work. What will work is if you change the database context to <code>master</code>, then run it like above. Or you run the following:</p>
  
  <pre><code>EXEC master.dbo.fn_blah
  </code></pre>
  
  <p>Anyone seen this kind of behavior before? Any help is appreciated. Thanks!</p>