What are the challenges you face when working across database platforms? Take the survey

DLM build fails for views but not store proc?

10raw10raw Posts: 20 Bronze 1

DLM build fails while building a view which script contains database reference while calling an object but sproc does not fails even though they have similar database reference call. For example

FROM databasename.schemaname.table in a view fails but

FROM databasename.schemaname.table in sproc does not fail.

If I remove databasename from view script to change it to schemaname.table in view then it builds too.

Best Answer


Sign In or Register to comment.