[sriyaz]

Hi,

I have Sybase user store procedure(1000+) in the user database.I want to recompile all store procedure at a time.
Are there any procedure to recompile all Store Procedure at a time?

Thanks in advance.

Regards,
Shaikh

[trvishi]

use <database>
go
select "exec sp_recompile "+name from sysobjects where type='U'
go

Copy paste the output and run.

type='U' is for table names.

[karthi_syb]

You can also use dynamic sql to do this.

[sriyaz]

Thanks Karthi,

Can you please give me an example of dynamic sql.

We migrated Sybase 12.5 32-bit to Sybase12.5 64-bit.
We are getting problem while compiling the SP.
Can you please suggest me Which is the easiest way to recompile all SP in one-shot.

Thanks in Advance.
Sriyaz