mirroring and clr RRS feed

  • Question

  • I have a mirrored database with clr assemblies.
    clr is enanbled on boith servers and is_trustworthy_on is true on both servers.
     all worked fine for a while and suddenly no clr functioned. I changed the dbowner to sa and they still didn't work
    I stopped the mirror with still no positive effects. only after
    detaching and reattaching the db and they started functioning again

    any idea why this happened and how it can be prevented from happening in the future

    Wednesday, February 25, 2009 5:24 PM