I am attempting to call a user defined function from a stored procedure in the same database, and I get the following error:
Invalid object name 'dbo.fn_NewSplit'.
I've tried calling it as dbo.fn_NewSplit, fn_NewSplit etc. I also setup another that had my DB login IE ihomesm_maindb.fn_NewSplit and get the same results.
Interestingly there is another previously built stored procedure calling the same function with apparantly no problems.
Invalid object name 'dbo.fn_NewSplit'.
I've tried calling it as dbo.fn_NewSplit, fn_NewSplit etc. I also setup another that had my DB login IE ihomesm_maindb.fn_NewSplit and get the same results.
Interestingly there is another previously built stored procedure calling the same function with apparantly no problems.