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 |
|
divyapatel50
Starting Member
1 Post |
 Posted - 2011-10-12 : 23:48:39
|
| I converted DTS into SSIS and when it updates one table data it locks entire database so the front end reporting application is not able to use the database. How to prevent block for other processes. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-13 : 02:10:01
|
| does table have a clustered index? whats the amount of data its trying to update?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSIS locks database