I have a database that I inherited and I see the server is building views that I do not have access. I believe that are no longer valid/used but I am not able to see them. I have manager access to the database, do I have any options to delete views that my id cannot see? Any options from the server console?
Thanks
David
Subject: Delete hidden views
Could they be private views?
Try opening the db locally from the server (assuming you have a client installed on the server box). That should show you any private views and the name of the person who created them in designer.
The easiest way to remove them is to create a new replica of the database and replace the original db with the new replica.
HTH - Rufus.
Subject: RE: Delete hidden views
I have thought of that but this database is on several servers and a subset is on ~300 users. For this to work I would have to delete all replicas? Or just the server replicas? I’ll try the server id option