var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sybase Store Procedure
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.
select "exec sp_recompile "+name from sysobjects where type='U'
Copy paste the output and run.
type='U' is for table names.
Last edited by trvishi; 06-24-08 at 12:52.
You can also use dynamic sql to do this.
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.