August 5, 2004 at 3:59 am
Hi there,
I've restored a backup of a productiondb to a developerserver. This db was subscriber in a replicationproces and includes a lot of views for this subscription. I don't need those view and would like to delete them. Dropping those views is met with the nessage:
You were trying to delete system objects. They were not deleted.
How can I remove those views? They're not in the way, but also unnecessary.
Greetz,
Hans Brouwer
August 5, 2004 at 8:00 am
I don't think you want to delete and system objects yourself. If they were setup, you want to use EM to remove the subscriptions.
If you really want to, you can run sp_configure with the "allow system updates" parameter and then you could delete them.
August 5, 2004 at 8:37 am
Tnx for responding, STeve.
Since the database is a COPY of a subscriber and not part of a replicationproces it is not possible to disable the subscription.
I do not know the allow system updates option; I do know the alow updates option. This enables users to change data in systemtables.
This will not do the trick. I'm trying to find out were the type of the object is stored; maybe I can change that from system tu user. DOubt that it wll be that easy.
Greetz,
Hans Brouwer
August 5, 2004 at 2:07 pm
Are they system views? You'd better leave system objects untouched even if you've got a way to delete them - doing so could be seriously detrimental to your server.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply