SQL Server Performance

stored procedure creating again and again

Discussion in 'Getting Started' started by sultan_i, Jun 20, 2007.

  1. sultan_i New Member

    In my production environment, some of the stored procedures are creating automatically again and again. Why this is happening ?. There is no create procedure in my quries. There is no recompile option specified in that procedures. All the stored procedures are created during the installation time only. There is no drop procedure statements to recreate these. Is it possible to create procedure automatically some intervals of time ?. Any one can you help me ?


  2. Madhivanan Moderator

    How do you know they are created automatically?
    Can you give us the names?


    Failing to plan is Planning to fail
  3. sultan_i New Member

    from the detail trace my production support team member telling that it is creating again and again. He send me some blocking report, in that also i can able to see the create procedure statement


  4. satya Moderator

    Run PROFILER to see what kind of activity over there. Your explanation doesn't bring any information or detail to look into it.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page