Results 1 to 2 of 2

Thread: recompile the strored proc

  1. 07-18-2003, 10:02 AM #1
    ravi
    ravi is offline Registered User
    Join Date
    Nov 2002
    Posts
    231

    recompile the strored proc

    Hi,
    Do we need to Recompile the Stored Proc as part of our daily Maintenance Plan?.
    Could you please give me the Script for recompile all stored proc in entire server.
    Thanks,
    Ravi
    Reply With Quote Reply With Quote
  2. 07-18-2003, 10:04 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    You dont need to unless you change the structure and sql server will take care of it.

    we discussed something about this before


    here is the link

    http://forums.databasejournal.com/sh...ight=recompile
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules