On deleting systemobjects

Question

On deleting systemobjects

FreeHansje

SSChampion

Points: 11751
More actions
August 5, 2004 at 3:59 am

#86212

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

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 738897 More actions · Answer 1

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.

FreeHansje SSChampion Points: 11751 More actions · Answer 2

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

acedba SSChasing Mays Points: 617 More actions · Answer 3

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.