Solved

To delete system views created by replication.

Posted on 2010-08-18
2
470 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

867 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

16 Experts available now in Live!

Get 1:1 Help Now