Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2008
    Posts
    22

    Unanswered: Sybase Store Procedure

    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

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    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.
    Last edited by trvishi; 06-24-08 at 12:52.

  3. #3
    Join Date
    Jun 2008
    Location
    India
    Posts
    96
    You can also use dynamic sql to do this.

  4. #4
    Join Date
    Mar 2008
    Posts
    22
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •