Hi madam, I am getting Error SQL71501: Error validating element [dbo].[vwname]: View: [dbo].[Vwname] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[tablename].[columname]. In this view, function is calling from the same db to fetch some values is causing the error, if I comment the function exporting without issue. But this function is required in the view. How can I overcome this issue with out commenting the functions inside view. Kindly advise, thank you.
This was very helpful and easy to follow. Thanks for the effort!
Thanks. Glad it was helpful!
great
Thanks
Can we import the backpack file within the server with the new db name?
Thank you for this great guide! I have one question: can i change the collation during the database import?
Hi madam, I am getting Error SQL71501: Error validating element [dbo].[vwname]: View: [dbo].[Vwname] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[tablename].[columname].
In this view, function is calling from the same db to fetch some values is causing the error, if I comment the function exporting without issue. But this function is required in the view. How can I overcome this issue with out commenting the functions inside view.
Kindly advise, thank you.
Hi, Can you share the documentation link here
Please, Use a better mic.