title: sql server giving error : is not a recognized function name
body: <p>I created a backup of a database on sql server 200. I created a new database in sql server 2008 r2.</p>
  
  <p>Now when i run a view i get the error :</p>
  
  <pre><code>'function_name' is not a recognized function name.
  </code></pre>
  
  <p>The function is there
  And i can run it using </p>
  
  <pre><code>   SELECT [dbo].[function_name] (
     'hjh')
  GO
  
  
   SELECT dbo.function_name('kjk')
  </code></pre>
  
  <p>Why would this problem occur when it is functioning correctly originally? </p>
  
  <p>EDIT:</p>
  
  <p>I think it may be a security issue as schemas owned by the user under dbo does not contain antyhing?</p>