"P.Simpe-Asante" wrote:

> One more thing - in most (but not all) cases, code that you write in a
> 'normal' .NET application will also work in a Service, including sql database
> commands...
>
> Patrick
>
> "P.Simpe-Asante" wrote:
>
> > Hi Bob,
> >
> > Sounds like a Windows service is probably your best bet, and it works quite
> > well... I've done this myself a few times before for my clients, so
> > unfortunately I can't show my own code here - have a look at this example
> > (includes Timer-based functionality):
> >
> > http://www.developerfusion.com/show/3441/1/
> >
> > HTH,
> > Patrick
> >
> > "BobHutch" wrote:
> >
> > > I am trying to create a windows service using vb.net to read a sql table
> > > every half hour and copy all new records created within each half hour
> > > increment to another table. I also want to be able to email each new record
> > > to a specific person. This system will need to run automatically. I know I
> > > can do this using an exe com component using windows scheduler to trigger the
> > > com componet, but I think that I can create the same type of application
> > > using vb.net to create a windows service. Can I use this approach and is
> > > there any good examples of using vb.net sql database commands when creating a
> > > windows service?
> > >
> > > Thank you