Getting notification from SQL 2005

[Andrea Caldarone]

Hi all,

I'me using VB 2003 with framework 1.1, and SQL Server 2005 Express as data
provider. Is there a way to get notification from SQL Server 2005? I try to
explain better, let's consider a canonical client - server scenario: one
client changes a data into the SQL 2005 database, this one notifies all the
other clients of the occourred change, the clients pull the changed data
from the database.

 

[William \(Bill\) Vaughn]

Yes, there is a new mechanism in SQL Server 2005 that can do this
implemented as Notification Services. It requires the 2.0 Framework and SQL
Server 2005 but I don't think it's exposed by the Express Edition--Workplace
or better. There are a narrow range of applications where this makes sense.
Yours might be one of them... Do some further study--it's targeted for an
upcoming EBook.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)

 

[Guest]

Yes, there is a new mechanism in SQL Server 2005 that can do this
implemented as Notification Services. It requires the 2.0 Framework and SQL
Server 2005 but I don't think it's exposed by the Express Edition--Workplace
or better. There are a narrow range of applications where this makes sense.
Yours might be one of them... Do some further study--it's targeted for an
upcoming EBook.

I also have a related question regarding to the topic.
I am using VS 2005 with SQL 2005 Compact Edition.

Is it possible to get notifications when a data is written to the
database?

Thank you in advance.

P.S.
When is "Hitchhiker's Guide to SQL Server 2005 Compact Edition" coming
out? ;p
I've been waiting for it ever since I heard about the first Ebook was
announced.
Even signed up for the notification email like a month ago..

 

[William \(Bill\) Vaughn]

The Compact Edition does not support any type of Notification Services. It
doesn't even have triggers (at least not yet).
Ah, we've been selling the Compact Edition EBook for some time now. See
www.hithchhikerguides.net.
The "earlybird" discount is still in effect (for now). Let me know if you
have any problems.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

 

[Guest]

The Compact Edition does not support any type of Notification Services. It
doesn't even have triggers (at least not yet).

Thank you for the response there, Bill.
Ah.. well.. I think i can live with it... without that feature...

Ah, we've been selling the Compact Edition EBook for some time now. See
www.hithchhikerguides.net.
The "earlybird" discount is still in effect (for now). Let me know if you
have any problems.

I have just purchased the book and man i would have to wait until
tomorrow until the order is process. Can't wait to read!

 

[William \(Bill\) Vaughn]

Thanks for being patient. Peter Blackburn (in the UK) is processing these
orders. There is some manual processing as each copy is sent out with a
unique identifier to give you access to the website premium areas.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------