Wednesday, March 21, 2012 6:17 PM
[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.
Wednesday, March 21, 2012 8:14 PMModeratorIf 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
Wednesday, March 28, 2012 3:23 PMThanks, Bob.