Run a vb net procedure when sql table insert is triggered

9 Jun 2009 1:24 PM

Gum

I need to run a VB.Net 2008 procedure whenever there is an insert on a sql
table. Conceptually, I could create a trigger (either within Visual Studio
or SQL Server Mgmt Studio) that would be external. How can I create a VB.net
event that could be used to initiate action in a sub?

10 Jun 2009 5:41 AM

Cor Ligthert[MVP]

Hi Gum,

More an Framework AdoNet question,

But here is the link to the tutorial for notification services

http://msdn.microsoft.com/en-us/library/ms170337(SQL.90).aspx

Cor

Show quoteHide quote

"Gum" <gum@nospam.nospam> wrote in message
news:47AF80F5-69A0-4C3D-9BC6-554DDF5F8E3B@microsoft.com...
>I need to run a VB.Net 2008 procedure whenever there is an insert on a sql
> table. Conceptually, I could create a trigger (either within Visual
> Studio
> or SQL Server Mgmt Studio) that would be external. How can I create a
> VB.net
> event that could be used to initiate action in a sub?

12 Jun 2009 6:25 PM

Gum

I will take your suggestion and try the Framework ADO.net group. The tutorial
for notification services looks interesting and I will look at that as well.

Show quoteHide quote

"Cor Ligthert[MVP]" wrote:

> Hi Gum,
>
> More an Framework AdoNet question,
>
> But here is the link to the tutorial for notification services
>
> http://msdn.microsoft.com/en-us/library/ms170337(SQL.90).aspx
>
> Cor
>
> "Gum" <gum@nospam.nospam> wrote in message
> news:47AF80F5-69A0-4C3D-9BC6-554DDF5F8E3B@microsoft.com...
> >I need to run a VB.Net 2008 procedure whenever there is an insert on a sql
> > table. Conceptually, I could create a trigger (either within Visual
> > Studio
> > or SQL Server Mgmt Studio) that would be external. How can I create a
> > VB.net
> > event that could be used to initiate action in a sub?
>
>