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.