This query isn't the problem child, but it could be a contributor if default is READ COMMITTED.
EDIT: Whoops. Can you also find out if your READ_COMMITTED_SNAPSHOT is set to on/off please?
Run this, see if you get any hits:
select
o.name
from
sysobjects o
join syscomments c
on o.id = c.id
where
c.text like '%BEGIN TRAN%'
and o.type IN ( 'p', 't')
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA