Symptom
- A view is created with a column based on a SQL UDF (User-Defined Functions) call.
- SELECT from the view from within the same database works fine.
- BCP out or a cross-database select from the view fails with error 2846:
Msg 2846, Level 16, State 1:
Server 'XXXX', Line 1:
SQL function 'dbo.title' not found. Specify owner.objectname or use sp_help to checkwhether the object exists (sp_help may produce lots of output)
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) on ALL versions.
Product
SAP Adaptive Server Enterprise all versions
Keywords
Msg, Server Message, 2846, view, UDF, User-Defined Functions, bcp, select , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.