Thanks Paul!
I think this solves this problem.
I run sp_depend on several of my objects that i suspect...
And in one of them the dependenies was wrong.
So i dropped it and recreated the view and run sp_depends agin.
Now the dependencies showd up correctly.
Thank you for your help!
Regards,
Johan
"Paul Ibison" <anonymous (AT) discussions (DOT) microsoft.com> wrote
Quote:
Johan,
as far as I understand, the order should be regulated
according to existing dependencies. Assuming you are
replicating both views, could you run sp_depends on the
view that errors to check that the dependency is
acnowledged by SQL Server. If this shows no dependencies
then refresh the view and run it again.
Regards,
Paul Ibison |