Hi @bushels ,
Did you use a valid login name?
After Right clicking on the database->properties->files, you can see the file owner.
If it’s the owner’s error, click security->logins->login properties->user Mapping and then you can make some changes.
It may be a timeout problem caused by your large amount of data.
As for clearing cache, use
DBCC FREEPROCCACHE to clear the procedure cache and use
DBCC DROPCLEANBUFFERS to test queries with a cold buffer cache without shutting down and restarting the server.
Get your views:
use [yourdatabse] select * from sys.sysobjects where type='v'
To get the definition and properties of a view and recreate views.
The last method is not recommended and you can try. In the final analysis, you have too much data. You need to manage your big data, otherwise there will be other performance issues.
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.