Hi,

Inside a single transaction I'm inserting/updating multiple records into
multiple tables, like this:
table 1 record 1
table 2 record 1
table 3 record 1
table 1 record 2
table 2 record 1
table 1 record 3
table 2 record 3
table 3 record 3

Now I'm getting an unspecified error on a certain table:

Unspecified error [ 3,-1300704038,-1834095882,activitypointerBase,x lock (x
blocks),PAG (idx): 1078 ]

From msdn I see that:

PAG (idx) means a lock on an index page.
x lock means an exclusive lock:
Indicates a data modification, such as an insert, an update, or a deletion.
Ensures that multiple updates cannot be made to the same resource at the
same time. (I assume that multiple updates within the SAME transaction can
be made, only multiple updates from different transaction cannot be made,
right?)

I cannot find any reference to this error message and don't know what the
numbers mean. Maybe it relates to data that can be found in the
sys.lock_information table like explained here,
http://technet.microsoft.com/en-us/library/ms172932.aspx, but I'm not sure.

Furthermore, the sys.lock_information table is empty. I haven't been able to
reproduce the problem myself. I only received an error log and the database
to investigate it.

So, does anybody have an idea what this error message means and what I can
do to troubleshoot this?

Thanks,