>>>If I still want to use it in SP, how can I make sure I declared DLL only once? Using aDLLs would probably slow it down the same way as repeating declaration?
>>
>>You could use db events but I wouldn't use it as an SP for this task.
>>Cetin
>
>I understand what do you mean by DBC events, but I don't understand the second part. What exactly do you mean?

Do not use SP to generate GUIDs when you're running this task.
PS: I forgot to tell, you said along the lines RI triggers were not firing before tableupdate. Yes it's the expected behavior but it doesn't matter, at the end they're firing. If they're firing to validate data that you already know is valid then come to think of it (but I know your tendency is to be conservative at all times).
Cetin