Hold on here. You're missing or forgetting something very important about the spiritual city and sanctuary that Christ has been building for a long time now. It can't be destroyed. The gates of hell cannot prevail against it (Matthew 16:18). But, Daniel 9:26 talks about a city and sanctuary that would be destroyed for certain, not a city and sanctuary that people would attempt to destroy and fail to do so. It says "the people of the prince that shall come SHALL DESTROY the city and the sanctuary", not "the people of the prince that shall come shall TRY TO DESTROY the city and the sanctuary, but will fail to do so". So, you are taking the verse completely out of context while not realizing you are contradicting other scripture in the process.
And what you are missing here is that I take this spiritual city and sanctuary to mean the ppl themselves, thus the saints that become saved during the church age, and then I apply what is recorded in Daniel 8 per the following, for example, to that of what is recorded in verse 26 in Daniel 9 pertaining to destroying the city and sanctuary.
In Daniel 9:26 the Hebrew word for destroy is shachath
shachath
shaw-khath'
a primitive root; to decay, i.e. (causatively) ruin (literally or figuratively):--batter, cast off, corrupt(-er, thing), destroy(-er, -uction), lose, mar, perish, spill, spoiler, X utterly, waste(-r).
shachath is also used in the following passages in the book of Daniel.
Daniel 11:17 He shall also set his face to enter with the strength of his whole kingdom, and upright ones with him; thus shall he do: and he shall give him the daughter of women, corrupting(shachath) her: but she shall not stand on his side, neither be for him.
Daniel 8:24 And his power shall be mighty, but not by his own power: and he shall destroy(shachath) wonderfully, and shall prosper, and practise, and shall destroy(shachath) the mighty and the holy people.
25 And through his policy also he shall cause craft to prosper in his hand; and he shall magnify himself in his heart, and by peace shall destroy(shachath) many: he shall also stand up against the Prince of princes; but he shall be broken without hand.
Daniel 11:17 aside since there appears to be no connection to that, what about what is recorded in Daniel 8:24, 25, per the following? Then notice something relevant here. When shachath is being used elsewhere in the book of Daniel it appears to never mean destroying, as in destroying literal buildings, etc. I'm not insisting that is true of shachath in general, that it never means destroying something literal, such as buildings, etc. I'm only meaning how it is used elsewhere in the book of Daniel where it seems to mainly mean corrupting someone. Why would Daniel 9:26 be the odd man out and be meaning in the literal sense involving destroying literal buildings when it is not meaning in that sense anywhere else in the book of Daniel?
and he shall destroy(shachath) wonderfully
and shall destroy(shachath) the mighty and the holy people
and by peace shall destroy(shachath) many
All of this obviously pertaining to what is recorded in Daniel 8:9-14. But then notice what time period verse 25 is applying this to---he shall also stand up against the Prince of princes; but he shall be broken without hand.
It is beyond unreasonable to on one hand fully agree that Jesus is worthy of the title King of kings, Lord of lords, then on the other hand entirely disagree that He is also worthy of the title of the Prince of princes, that that title fits someone else way way way better than it does Him. Yeah, right. Clearly then, the Prince of princes is meaning Christ, therefore, it is ludicrous that the popular interpretation that has the little horn in Daniel 8 meaning A4E, that this is the correct interpretation. No it isn't. Christ wasn't even born yet when A4E was living. Therefore, it is preposterous that this---he shall also stand up against the Prince of princes; but he shall be broken without hand--can fit A4E somehow.
To summarize, I simply take this in Daniel 8:24-25---and he shall destroy(shachath) wonderfully--and shall destroy(shachath) the mighty and the holy people--and by peace shall destroy(shachath) many--to be involving this in Daniel 9:26--and the people of the prince that shall come shall destroy the city and the sanctuary
Who might the ppl of the prince be meaning if not pertaining to 70 AD? How about this for one, below? And why not? Clearly, a literal city and a literal temple is not meant per the following.
Revelation 11:1 And there was given me a reed like unto a rod: and the angel stood, saying, Rise, and measure the temple of God, and the altar, and them that worship therein.
2 But the court which is without the temple leave out, and measure it not; for it is given unto the Gentiles: and the holy city shall they tread under foot forty and two months.
There is your city and sanctuary being destroyed in Daniel 9:26, and the people of the prince that are doing it are the Gentiles meant in verse 2. obviously.
The way some of you interpret some Scriptures in a vacuum at times, then complain when Preterists do the same with much of the NT by having it all involve the first century up until 70 AD, it then makes one wonder why God even bothered revealing to Paul what He revealed to him per 2 Thessalonians 2 and what all that involves, and why God even bothered to reveal to John what He revealed to him per the book of Revelation and what all that involves, if exceptionally smart ppl such as yourself are unwilling to look any further than 70 AD pertaining to what is recorded in Daniel 9:24-27? I would get it if you were a Preterist or something. Yet you are not a Preterist, therefore, I don't get it.