Home Forums SQL Server 2005 Administering CPU 100%, current queries show "CREATE PROCEDURE ... " RE: CPU 100%, current queries show "CREATE PROCEDURE ... "

  • GilaMonster (9/27/2012)


    Boris Pazin (9/27/2012)


    The problem is that current queries are scripts for creating procedures, not for executing them.

    The procedures are not being created. They are being executed.

    When you execute a procedure, the sql_text DMV shows the create so that you can use the statement offsets to get the exact statement executing.

    Thanks!!!!

    Things finally make sense. :Wow: