rahultandon1000 wrote:
As this can be done on regular basis, I know it can be done by window service but how it can be used with c# and sql server 2005
So, what is you problem ? You want to create a Windows services which will regularly check your database and send the notification mail to the user ? If yes, then what is the point to post this question in ASP.NET Forum. You have to create a simple web service, which will call Some SP of of SQL server and retrieve the data from database. By the way you can do all the thing only using SQL server 2005 also ;)