drdeadpan (vkat01-nospam@yahoo.com) writes:
> Thanks as always. I did learn something from that.
> Ok, here's an easier one Erland. What can I infer from this?

First of all, you do have this information:

> DELETE Line #: 122
> 2005-01-13 09:00:10.64 spid4 Input Buf: RPC Event:
> Requisition_Scansample;1
>...
> CONDITIONAL Line #: 59
> 2005-01-13 09:00:10.64 spid4 Input Buf: RPC Event:
> Requisition_Scansample;1

That is procedure name and line number. Although if Requisition_Scansample
calls other procedures, the line number may refer to any these instead.

We also have:

> 2005-01-13 09:00:10.64 spid4 KEY: 7:1038026504:2 (17018f579faa)

SELECT db_name(7) will give you the database, and if you then
go that database SELECT object_name(1038026504) will give you
the table. Finally 2 is index = 2 for that table, check sysindexes.

And again:

> 2005-01-13 09:00:10.64 spid4 KEY: 7:1811953977:6 (420154596011)

Now you know the involved objects and you have some hint where it's
happening. Then use your knowledge about what's happening in
Requisition_Scansample to understand what is happening.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp