Working with Extended SP ( CLRSP )
i am very new to extended stoared procedure.
i want it to use to send multiple records to sp at once
can any one Explain me what is the exact excution sequance of CLRSP
is this method useful for my task
Plz Help me.
Its urgent.
[260 byte] By [
ppforpyxis] at [2007-11-20 3:51:38]
# 1 Re: Working with Extended SP ( CLRSP )
Basically U should avoid extended storage procedures. There are many penalties on stability and performance when using CLR (or standard dll extended SP). And there are so little cases when U can benefit from that (very, very complex calculations for example). When SP fails fatally, SQL server unloads CLR and all CLR funcionality is unavailable (until server restarts)
So better use ordinal stored procedure instead (especially when U are unexpirienced programmer).
Best regards,
Krzemo.
Krzemo at 2007-11-9 13:44:38 >
