Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to aviod dead lock while loading data simultaneously?
- Thread starter meilan
- Start date
You'll need to explain your system a bit more. How is the data being loaded? Is the data duplicated in the souirces?
If you are getting deadlocks - maybe your are loading multiple tables in a single transaction. Ensure you load tables in the same order for each source!
nick
If you are getting deadlocks - maybe your are loading multiple tables in a single transaction. Ensure you load tables in the same order for each source!
nick
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question