Re: update notification
From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 02/08/05
- Next message: Godbout: "Install/Uninstall MSDE under XP gives headaches..."
- Previous message: Andrea Montanari: "Re: msde2000 password"
- In reply to: sc: "update notification"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Feb 2005 18:29:25 +0100
hi,
sc wrote:
> Hi,
> If I have a change in a row in a table in a database, is it possible
> for MSDE to notify other users (connected to the same database) that
> the row/table has changed? I'm thinking of something like events
> (like in C# forms- control.OnChanged etc.). Or do I need a custom
> DataAccessLayer to do all this management?
> Thanks for your time,
> SC
DBMSs usually do not provide this feature as it would be a very resources
and time consuming task... immagine you have to provide this kind of info to
1000 different users and for 1000s of rows...
SQL Server, as long as all DBMS expects you to do your required tasks
(INSERT/UPDATE/DELETE/SELECT), providing your required feedback, if any,
that could be in the form of resultset(s) or just messages... when the
submitted batch operation has been executed, the connection (your
connection) will actually sleep until you provide further workloads to be
performed, and SQL Server will pick form it's internal que the next batch to
exec (from other clients too)...
as soon as you provide additional work, it will be enlisted and performed as
soon as it becomes on the top of the runnable lists, where the User Mode
Scheduler associated with your active connection will bring up that worker
(thread or fiber, dipending on the actual setting) and execute it..
-- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
- Next message: Godbout: "Install/Uninstall MSDE under XP gives headaches..."
- Previous message: Andrea Montanari: "Re: msde2000 password"
- In reply to: sc: "update notification"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
