the create assembly thing in sqlserver 2005 requires that the assy and
all its deps, be loaded into the internal sql binaries library. i dont
know if you can externally reference the gac for this. the bigger this
list gets the more modules have to be reloaded when changes occur and
new versions are issued. my feeling is that the code that runs inside
sql should be lean and mean.
it might be better to create a tiny stub sql clr assembly which drops
the request to a queue which is processed in an external service
outside sql. that way all the deps can be shared from the gac.
i am still getting up to speed with 2005 so there may be plenty of
things that i havent considered here.
Get your notification services implementation going in minutes not