• It's not creating the proc, it's running it.

    When you query sys.dm_exec_sql_text and the handle you pass is for a running stored proc, you get back the creation script for the proc. It does not mean that the proc is being created, it means that the proc is running.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass