I need to develop a WEB application with ASP e Sql-Server. Some users (always around the world) use this application also off-line with laptops (and with MSDE) also for insert and update data. Is it possible to use Replication with a server (Sql-server + IIS) and some laptops with MSDE? And how replication works with Identity fields (I insert a Order in my laptop with ID fields (identity) 100, if another user insert a Order from another laptop with id 100, when i put on line the laptop what happens
Sorry fro my english..

You can set up replication with one SQL Server and multiple MSDE instances.
You can work with identity column, as you can assign a range for each server
in the replication architecture to use. See "Managing Identity Values" in
Books Online.

--
Jacco Schalkwijk
SQL Server MVP


[quoted text, click to view]
(always around the world) use this application also off-line with laptops
(and with MSDE) also for insert and update data. Is it possible to use
Replication with a server (Sql-server + IIS) and some laptops with MSDE? And
how replication works with Identity fields (I insert a Order in my laptop
with ID fields (identity) 100, if another user insert a Order from another
laptop with id 100, when i put on line the laptop what happens?
[quoted text, click to view]