SQL Server Performance

after droping assembly can still call function

Discussion in 'SQL Server 2005 General Developer Questions' started by sql_machine, Jun 25, 2006.

  1. sql_machine New Member

    After I drop my assembly I can still execute my UDA, such as:

    CREATE ASSEMBLY ASSEMBLY_NAME
    authorization [DBO]
    from 'c:CLRmyexapmple.dll'
    WITH PERMISSION_SET = safe;

    then I execute my function


    DROP ASSEMBLY ASSEMBLY_MAME
    go

    I can still execute it now. How come?[:0]
  2. sql_machine New Member

    iN REPLY TO MY OWN QUESTION, I had to drop an aggregate first before droping an assembly.
  3. sql_machine New Member

    iN REPLY TO MY OWN QUESTION, I had to drop an aggregate first before droping an assembly.

Share This Page