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 - 2001-06-30 : 21:44:37
|
| Saravanan writes "I have developed an application (vb) which is currently running only one instance. Its functionality is reading mail content from the database and flushing them out. I need to run more than one instance simultaneously from different systems (to speedup email delivery). If one instance (app) access first record then second should access second record for processing. Likewise any number of instances should be possible to run simultaneouly. For this I have tried with row level lock with readpast. But I couldn't succeeded. Please find one of our trials (query) : "select * from MyTable with (READPAST ROWLOCK) where mycond = myvalue" (We are using Ado 2.5)" |
|
|
|
|
|
Client-Server app VB+SQLServer