Database upgrade script error

Chris Isom asked on October 18, 2016 22:55

While running the upgrade script on the database I am getting the following error:

Msg 3701, Level 11, State 5, Line 70Cannot drop the view 'View_custom_SurvivorStory_Joined', because it does not exist or you do not have permission.

I have validated that the user is db_owner and the view 'db_owner.View_custom_SurvivorStory_Joined' exists. Any thoughts on the matter would be helpful.

Thanks

Recent Answers


Roman Hutnyk answered on October 19, 2016 14:34

Is db_owner the equivalent of dbo? if not - this could be an issue.

If this is the only issue I'd say go ahead and manually drop it.

0 votesVote for this answer Mark as a Correct answer

David te Kloese answered on October 19, 2016 15:02

I'd say connect to your DB server using the same credentials your installation uses to see what you may (or may not do). Easier to test/debug any changes.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.