• Thanks Mayank, JAson for all your response..

    I have noticed one more thinj..

    (1) While executing the query as:: DBCC inputbuffer(77)--SPID,

    I'm getting one result.

    ---------------------------------

    Output::

    Exec ImportComponents '459087',''

    (2) DECLARE @HANDLE BINARY(20)

    SELECT @HANDLE = sql_handle from sys.sysprocesses where spid = 77

    SELECT text FROM ::fn_get_sql(@handle)

    Executing the above query, getting other result.

    --------------

    Output::

    UPDATE Material WITH ( ROWLOCK ) SET LastModifiedDate = '2009-08-31 12:07:19.917' , LastModifiedBy = 459087 , ChangeID = 2151042 FROM Material WHERE MaterialID = 1466288 UPDATE MaterialComponentDetail WITH ( ROWLOCK ) SET LastModifiedDate = '2009-08-31 12:07:19.917', LastModifiedBy = 459087 , ReplacedByPartNumber = 'X15-05816-02' FROM MaterialComponentDetail WHERE MaterialID = 1466288

    Can you please suggest why is this so??

    Regards

    Sourav

    Thanks.