Solved

To delete system views created by replication.

Posted on 2010-08-18
2
465 Views
Last Modified: 2012-08-13

I have deleted all the replications, publications,subscriptions from my server.

There are many synobj views which were not deleted by system.

the view names are like
syncobj_0x3533464132323033
syncobj_0x3138463935344234
syncobj_0x3130454430424245
syncobj_0x3830354145374444
syncobj_0x4435313930423141
syncobj_0x3136433335433042
syncobj_0x3739343743384145
syncobj_0x3835444346433032
syncobj_0x3333363034413945
syncobj_0x4342423330314446

Is it safe to delete these views manually?
What is the safe method of delete?
0
Comment
Question by:Mehram
2 Comments
 
LVL 3

Accepted Solution

by:
PrakashRaoBS earned 500 total points
ID: 33462937
These objects are used when generating the snapshots. If your table is
large, or if your article on the publisher is different from the article on
the subscriber (horizontal or vertical partitioning - in other words a
different number of rows or columns), SQL Server chooses to replicate from
views (called sync objects) instead of the underlying base tables.

If your replication is not active then you can drop these views. Otherwise if you drop the views, it will get affect one the replication snapshot is getting synced.

These system views are used during the snapshot process. Instead of deleting these views, You could assign them to the db_reader role.
0
 

Author Closing Comment

by:Mehram
ID: 33498182
Thanks
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now