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 |
|
jtwork
Yak Posting Veteran
82 Posts |
 Posted - 2008-11-11 : 07:46:36
|
| Using an openquery i am pulling data from an oracle server which takes around 2.5hrs per day. I'm dropping the table if it exists and then doing a select into from the oracle server. This seems to lock the sql server db im doing the select into. Is there anyway to prevent it from locking the db? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-11-11 : 08:55:25
|
| Do the data load in smaller batches. |
 |
|
|
|
|
|
Locking Database