?
Solved

To delete system views created by replication.

Posted on 2010-08-18
2
Medium Priority
?
494 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
PrakashRaoBS earned 2000 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

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

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.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

765 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