CLR Objects - impossible to remove schema replication from..

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.

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

"geraint" <ger_at_beff.co.uk> wrote in message
news:aZidnRAXZJFPkz3VnZ2dnUVZ8qydnZ2d@posted.plusnet...
> 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.
>