When i call user defined function from stored procedure, i am getting an error.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.MyFunction'.
why this error is happening?.
i am calling this way... dbo.MyFunction(param1,param2)
Can you give the full statement? This still does not look like enough information.
|||My first guess would be that your funciton is not residing in the same database as the stored procedure.
No comments:
Post a Comment