- 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)
SAP Adaptive Server Enterprise (ASE) on ALL versions.
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 pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.