No problem.

FYI, there is COPY PROCEDURE which copies them into the text file.

Kev

>Brilliant, thank Kevin
>
>>Hi Caroline
>>
>>Place all of your stored procedures into a text file, then issue:
>>

APPEND PROCEDURES FROM cTextFile

>>
>>You can also issue OVERWRITE to overwrite any that are there.
>>
>>Kev
>>>Hi all,
>>>
>>>Could someone please tell me how I can programmatically update a stored procedure of a database?
>>>
>>>Thanks in anticipation.