Re: Database events - notify an application

From: Mike Hildner (mhildner_at_afweb.com)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 09:31:24 -0700

Linda,

Thanks for the information. I thought the only way to do something "outside"
of sql server was an extended stored procedure. Much appreciated.

Mike

"lindawie" <lindawie@my-deja.com> wrote in message
news:eiw1YuxBEHA.3524@TK2MSFTNGP10.phx.gbl...
> Mike,
>
> > I have an application that polls the db every few seconds to
> > refresh the data. Would like to change so that the db sends a
> > message to my app when something interesting happens
> > (insert/update etc.).
> >
> > I've looked into sp_addmessage, raiseevent etc, but it seems
> > limited to pager, email and net send. I don't think I want to do
> > net send as it may be disabled and don't want to trap all net
> > send messages on the client.
> >
> > So I was thinking of writing and extended sp that, say, would
> > send a message via udp, this xp would get called via triggers.
> >
> > Am I on the right track, or are their smarter ways to do this?
> > sql server 2000.
>
>
> You could look at Notification Services:
>
> http://www.microsoft.com/sql/ns/default.asp
>
> Or you could write a simple console application that notifies your
> application when something interesting happens. Create a SQL Server
> Agent job to run the notifier. Execute sp_start_job in your triggers
> to run the notifier asynchronously so it will not impact your
> database transaction.
>
> Linda
>

Relevant Pages

  • Re: Extended Stored Procedure: Loopback connection
    ... SQL Server ships a sample exactly showing this: ... SQLRETURN sret, ... SRV_PROC* srvproc); ... NULL, 0, 0, "Error executing extended stored procedure: ...
    (microsoft.public.sqlserver.odbc)
  • Re: Implementation of full text
    ... There is no documented way of accessing the MSSearch catalogs directly other ... tables in SQL Server to identify the row the hit occurs in. ... table to a client from an extended stored procedure. ... To use the recordset returned from the ESP as a virtual table>. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: sql server events on data create
    ... If I were to do this, I would set up the client to listen on a socket, write ... an extended stored procedure that can trigger this socket, ... triggers on the tables of interest to call this extended stored procedure, ... Or you could start a custom SQL Server trace event with the right filters? ...
    (microsoft.public.sqlserver.programming)
  • Re: There seems to be a memory leak in srv_paraminfo
    ... > no memory leak but the sqlservr.exe memory usage went up so i thought ... will i have to restart sql server 2000 now and then ... > w/ a sample extended stored procedure that comes on the SQL Server 2000 CD ...
    (microsoft.public.sqlserver.programming)
  • Re: HasChanges returns false for one row, true when more than one
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... "Mike G Burton" wrote in message ... dataset has a single row, but True if the dataset has multiple rows. ...
    (microsoft.public.dotnet.framework.adonet)