Re: IRowsetResynch/IRowsetRefresh

Thanks for the suggestions everyone.
The SQL Notification Services sounds especially interesting.

Mark
--------------------------------------------------------------
Mark Dawson ([email protected])
Software Project Leader
Schenck Test Automation Ltd.
Lowesmoor Wharf, Worcester.
WR1 2RS. UK
+44 (0)1905 613361


-----Original Message-----
From: Niels Berglund [mailto:[email protected]]
Sent: 05 June 2002 15:14
To: [email protected]
Subject: Re: [OLEDB_DEV] IRowsetResynch/IRowsetRefresh


Mark,

I've done my fair share of sp_OAxxx calls, and IMHO if you need that kind of
functionality you are much better off writing extended procs instead of
using sp_OAxxx. You have much better control and you are not limited to
instantiating IDispatch based COM objects.

MS has just released [1] a new interesting framework in beta called SQL
Server Notification Services, which allows you to notify clients/apps about
changes in the database (or wherever else for that matter). It's well worth
to have a look at before next version of SQL Server is released.

Niels

[1] http://www.microsoft.com/sql/evaluation/nsbeta.asp

________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________

You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.