Hello Sim,

>>I found that all stored procedures code are stored
at syscomments ctext and text columns, but ctext is
some binary data, so how can I go about updating it ?

As Ric said, usually one would drop the old SP, then create the new SP. AFAIK, Microsoft does not publish the information you're asking.

Side note: With Sql 2005, it looks like you could create your own SP in a managed language, and even late bind to it. Cool.

Mike