RE: CLR Triggers on SQL 2008 R2 // Disable vs. Drop

SSC Guru

Points: 1003863

August 8, 2014 at 3:40 pm

sgmunson (8/8/2014)
Um... that's not actually an option. Don't get me started on the why...

Heh... been there, done that and totally understood. No explanation needed.

Assemblies are stored in the database and are backed up and restored just like anything else. Beyond that, I'd have to hit BOL and/or "Yabingooglehoo" for other questions/answers.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)