Recently I have had the pleasure of working on SQL Server 2008 R2 using the SQLCLR support.
Which I must admit it is quite nice to use, though a couple of things have anoyed me while using… one of which is the user of “DROP ASSEMBLY” and its dependancies…. normally this is not a huge problem but when you are write tests, it is good practice to remove/drop everything before deploying.
Being the sort of person that hates doing repetitively, I thought I would do a quick proc…. so let me introduce you to ‘MegaDrop’… yeah… its a rubbish name and the code is not elegant but it gets the job done..
Enjoy…
This entry was posted in CLR, SQL and tagged CLR, drop assembly, sqlclr. Bookmark the permalink.