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.