Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vasu4us
Posting Yak Master
102 Posts |
 Posted - 2006-11-30 : 09:53:30
|
| I am trying to join 6 tables from server A and pull the data into one single table in server B. iam getting this error.Transaction (processsid - 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim.Rerun the transaction.is it something to do with user access. iam not able to figure it outany help appriciatedthanks to all |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-11-30 : 21:52:21
|
| rerun and check what are the transactions causing the deadlock to occur, check if this has something to do with those 6 tables and some other transactions outside of your transaction... if it's within, you need to review how you are processing the dataHTH--------------------keeping it simple... |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-11-30 : 22:53:09
|
there are some traceflags you can set that will print out useful information to the sql logfile, also profiler can monitor them in 2005, detail below.http://msdn2.microsoft.com/en-us/library/ms178104.aspxhttp://msdn2.microsoft.com/en-us/library/ms191242.aspx
SqlSpec: a fast and comprehensive data dictionary generator for
SQL Server 2000/2005, Analysis Server 2005, Access 97/2000/XP/2003
http://www.elsasoft.org |
|
|
|
|
|
|
deadlocked error