Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / August 2008

Tip: Looking for answers? Try searching our database.

CLR Objects - impossible to remove schema replication from them????

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
geraint - 11 Aug 2008 11:05 GMT
Hi,

I've got a database that _was_ replicated at one point. The replication has
been removed, and doesn't exist any more.

BUT - there appears to be some replication artefacts hanging around for 4
objects.
Key info:
  - 4 objects in sys.objects have their is_schema_published values set to 1
  - These 4 objects are the only CLR functions/stored procedures in the
database. They are written in C# in a DLL. Neither the DLL nor the objects
can be dropped/altered.
  - _Every_ object (including the 4 mentioned above) in the database has
is_published = 0 in sys.objects
  - I've run sp_removedbreplication on the database - it doesn't change the
value of is_schema_published for these objects.
  - I've run sp_MSunmarkreplinfo on the 4 affected objects - again, no
effect
   -  There are no publications nor subscriptions on the database (e.g.
sp_helppublication returns nothing).

Does anyone have any idea how I can actually remove this replication so that
I can update or just delete the objects?!
Is it just a co-incidence that this replication "issue" only affects CLR
objects? Is this a bug?!

THANKS!

geraint.
Hilary Cotter - 16 Aug 2008 17:04 GMT
Is it possible for you to drop the assemblies and other related objects?

> Hi,
>
[quoted text clipped - 26 lines]
>
> geraint.
geraint - 26 Aug 2008 16:11 GMT
Ysgrifennodd "Hilary Cotter" <hilary.cotter@gmail.com> mewn neges
newyddion:FD2DA311-F938-4B32-A293-5B6AFD9787CF@microsoft.com...

> Is it possible for you to drop the assemblies and other related objects?

Nothing related to these objects can be dropped because the objects are
flagged for replication.
Also tried stopping SQL Server and deleting the assembly DLLs, then
restarting the server, and it still won't let me drop them.

I've ended up having to copy the schema across to a new blank database, then
populating the new database with the data from the previous one.
A lot of hassle/work, but there was no other way I could find of actually
removing these supposedly replicated objects.

ARGH!

hwyl!
geraint.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.