<div>
make sure that you created the function on the proper database with 'dbo.' &nbsp;prefix ,also make sure you are running the query on the same database 
</div>


make sure that you created the function on the proper database with 'dbo.'  prefix ,also make sure you are running the query on the same database

<div>
Yes, I did that, there are more then one fns I am using when I create this one and refreshed the Function tab, The function showed at the same place where the other fns are. But when I tried to call it from my procedure. I typed in &quot;dbo.&quot; in my procedure. the other fns showed up but this new one did not.
</div>


Yes, I did that, there are more then one fns I am using when I create this one and refreshed the Function tab, The function showed at the same place where the other fns are. But when I tried to call it from my procedure. I typed in "dbo." in my procedure. the other fns showed up but this new one did not.

<div>
may be you didnt run that function 
</div>


<div>
<div class="content wysiwyg-content">
Dear Expert, I create a function fn_Gender with 2 parm returning a table called gender. After I created the function and tried to test the function, I wrote &quot;select * from dbo.gender (1,2). the function name is red, The message said:&quot;Invalid Object Name dbo.fn_Gender.&quot; when I run it, it returned me the correct results. But when I use a stored procedure to call this function, The stored precedure returned the same message and could not run.<br />
Please help!<br />
John
</div>
</div>


Dear Expert, I create a function fn_Gender with 2 parm returning a table called gender. After I created the function and tried to test the function, I wrote "select * from dbo.gender (1,2). the function name is red, The message said:"Invalid Object Name dbo.fn_Gender." when I run it, it returned me the correct results. But when I use a stored procedure to call this function, The stored precedure returned the same message and could not run.
Please help!
John

Why my SQL Server stored procedure can not see my function?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.