• Akash Agarwal (8/13/2008)


    I m getting ther error on the line

    CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle) qt

    while creating the Proc

    The error is

    Msg 102, Level 15, State 1, Procedure dba_QueryTimeDelta1, Line 49

    Incorrect syntax near '.'.

    Please Guide

    Thanks

    Akash

    Are you using SQL server 2005?

    It won't work on lower versions.