January 27, 2009 at 8:43 am
We have some sp in 2000 which update one table X from another table Y (one record from table Y correspond to 2 records in table X).
When running this sp in 2005, it hangs.
When we cut of the sp in 2 steps it works.
any ideas what could be the problem?
January 27, 2009 at 11:36 am
Are you running this in SSIS? Any locking issues?
Try running profiler with deadlock events: Deadlock, DeadLock Graph and DeadLock chain. Also include the SQL Stmt completed and sp events. or look at the activity monitor.
January 27, 2009 at 11:52 am
Have you tested the SP by itself, not as part of a package?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply