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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-08 : 10:13:50
|
| tc writes "Im am running a DTS package to update a SQL2000 database, which uses the option join in transaction in some of the task. When users try to query(read only) the database from the web page when I am updating the database they get a lot of timeouts. It seems as if the tables that the DTS package is working on is locked and do not free up until the package is complete. This package runs every 30 minutes. Is there anything that I can set that will still allow the users to read the tables even though the task in the DTS package have a lock on them." |
|
|
Jay99
468 Posts |
Posted - 2002-03-08 : 10:41:55
|
SQL Server locks for a reason . . . That being said . . .select fieldfrom table with (nolock) Jay |
 |
|
|
|
|
|
DTS Package