SQL Server Error Msg 21845 – Can not alter procedure ‘%s’ to depend on an indexed view published as ‘indexed view logbased’ or a base table because the indexed view depends on this table as well.

In this blog post, let’s learn about the error message “21845 – Can not alter procedure ‘%s’ to depend on an indexed view published as ‘indexed view logbased’ or a base table because the indexed view depends on this table as well.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

21845 – Can not alter procedure ‘%s’ to depend on an indexed view published as ‘indexed view logbased’ or a base table because the indexed view depends on this table as well.

Reason for the Error

To be update soon…

Solution

To be update soon…