Post reply

sp_recomplie - recompile all stored procedures and fuctions

  • March 4, 2012 at 11:38 pm

    #256908

    Hi All,

    Can someone please provide the script for " sp_recomplie - recompile all stored procedures and fuctions" in all databases in SQLServer2005.

    Thanks and Regards,

    Ravi.

  • March 4, 2012 at 11:52 pm

    #1454644

    This sounds like an interview question.

    You can achieve what you want through a DBCC command, take a look at books on line.


    Clear Sky SQL
    My Blog[/url]

  • March 5, 2012 at 12:54 am

    #1454662

    How to execute the storedprocedure in all databases? as I want to schedulre it in sqlserver job

    EX: if we want to execute SP in specific db

    USE DATABASENAME

    EXEC SP_STOREDPORCEDURE

    I want it to execute in all dbs.

    Please advice.

    Thanks and Regards,

    Ravichandra.

  • March 5, 2012 at 1:46 am

    #1454672

    You can use sp_MsForEachDB or any other replacement[/url] for that.

    -- Gianluca Sartori

  • March 5, 2012 at 3:39 am

    #1454708

    How about simply running DBCC FREEPROCCAHCE

    http://msdn.microsoft.com/en-us/library/ms174283.aspx

    Jayanth Kurup[/url]

  • March 6, 2012 at 7:49 am

    #1455321

    ravisamigo (3/4/2012)

    Hi All,

    Can someone please provide the script for " sp_recomplie - recompile all stored procedures and fuctions" in all databases in SQLServer2005.

    Thanks and Regards,

    Ravi.

    Anytime I see a question like this on a forum the first thing that pops into my head is "WHY do you want to do this"? Lets address that before we talk about HOW you do it. 😎

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply