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-09-10 : 09:17:11
|
| Lennart Nystrom writes "I am a "SQL beginner" trying to design an application as follows:From an iPAQ with SQL Server CE a user will "PULL" records from a remote SQL Server 2000 to create a local database on the iPAQ. When doing this we would like to have the pulled records locked on the SQL Server 2000. After pulling the records to the iPAQ the user will disconnect from the Network and work stand-alone for a day or so and then connect to the Network and "PUSH" the updated records to the SQL Server 2000. These updated records should now be unlocked. During the time the records are locked on the SQL Server 2000 and a second user tries to access them it would be nice for him to get a message who locked the record and when! I guess we also need some kind of a watchdog timer to watch for records never beeing unlocked ? Any ideas ?" |
|
|
|
|
|
WindowsCE,replication,record locking,SQLServer 2000