Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Updating existing CLR trigger - an easier way?

Answered Updating existing CLR trigger - an easier way?

  • Wednesday, March 21, 2012 6:17 PM
     
     
    Sign In to Vote
    0

    [Running SQL Server 2005]

    I have a test case CLR DML trigger up and running. However, it seems tedious to update to a new version of the .dll:

    - Compile .dll
    - Delete existing trigger
    - Delete existing assembly
    - Re-create assembly
    - Re-create trigger

    Is there some method requiring fewer steps that I am missing? Thanks for any assistance.

     

All Replies

  • Wednesday, March 21, 2012 8:14 PM
    Moderator
     
     Answered
    Sign In to Vote
    1
    If you don’t change any of the method signatures of the items declared to T-SQL (which you wouldn’t for DDL trigger because it accepts no input parameters), you can simply do ALTER ASSEMBLY..... I haven’t tried with SSDT in SQL Server 2012 yet, but VS2010 auto-deploy doesn’t support ALTER ASSEMBLY, you’ll need to code the DDL.
     
    Cheers,
    Bob
    • Proposed As Answer by pen_2 Monday, March 26, 2012 2:09 PM
    • Marked As Answer by KJian_ Wednesday, March 28, 2012 6:10 AM
    •  
     
  • Wednesday, March 28, 2012 3:23 PM
     
     
    Sign In to Vote
    0
    Thanks, Bob.