Windows Services

  • Thread starter Thread starter geekyguy
  • Start date Start date
G

geekyguy

Hi All: I'm not sure where to post this so please redirect me if
appropriate.

I've been looking around for ways to create a "birthday reminder" that would
email a message to everyone in a SQL2005 dB whose birthday is that day. I
want to run it as a service on the webserver (the SQL server is a separate
box).

Googling turns up some info on writing a windows service in VS.NET, but much
of it is outdated. Where would the best place be to start in researching how
to do it?
 
There isn't much change (if any at all) for doing Windows Services app in
all VS.NET versions (2002, 2003, 2005 and 2008). Not sure how do you decide
what is "outdated".
 
Norman Yuan said:
There isn't much change (if any at all) for doing Windows Services app in
all VS.NET versions (2002, 2003, 2005 and 2008). Not sure how do you
decide what is "outdated".
Click to expand...

Thanks Norman. Do you have any suggestions of where I should start, or is
this an appropriate newsgroup to post in?
 
Couldn't you create a job in sql server that does this?

Hi RHaazy: Normally yes, but in this case no...so it needs to be a windows
service.
 
Does it really have to be a windows service or could you make a win32
app and create a scheduled task?
 
Does it really have to be a windows service or could you make a win32
app and create a scheduled task?

Hi Rhaazy...I've thought about that, and I've encountered a lot of problems
with task scheduler and was looking for a better-integrated solution. Also,
I wanted to create a one-step install process that didn't require user
intervention.
 
Back
Top