CLR Objects - impossible to remove schema replication from them????
geraint
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
"geraint" <ger_at_beff.co.uk> wrote in message
news:aZidnRAXZJFPkz3V...@posted.plusnet...
geraint
Ysgrifennodd "Hilary Cotter" <hilary...@gmail.com> mewn neges
newyddion:FD2DA311-F938-4B32...@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.