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 |
|
ay2k_99
Starting Member
22 Posts |
 Posted - 2009-05-01 : 08:21:46
|
| Hello,We have specific application for our organization, our senario is like...1) We have ETL reporting tool which getting the data from source tables and generate the report. But that time of period it is taken the share lock on those tables. i change the Isolation levels also.2) at the same time other Application is inserting the data from other database on reporting database tables. but before it clear the data from source table and that time it applied the (Truncate sta) but it was wait for 1st transaction to the data and deadlock occur.is there any solution when select is going on and delete the data from source table....THANKS :) |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-05-02 : 03:06:41
|
quote:
Originally posted by ay2k_99
Hello,We have specific application for our organization, our senario is like...1) We have ETL reporting tool which getting the data from source tables and generate the report. But that time of period it is taken the share lock on those tables. i change the Isolation levels also.2) at the same time other Application is inserting the data from other database on reporting database tables. but before it clear the data from source table and that time it applied the (Truncate sta) but it was wait for 1st transaction to the data and deadlock occur.is there any solution when select is going on and delete the data from source table....THANKS :)
hey aren't you the guy that posted a similar question but in a different way...Regards,Ahmad Osama |
 |
|
|
ay2k_99
Starting Member
22 Posts |
Posted - 2009-05-04 : 00:03:01
|
| yES.... |
|
|
|
|
|
|
Select + Delete or Ttruncate..