Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# SQL-Server ASP:NET
Hi,
How to Refresh the "security table" every night(to add new users and remove the users)??
 
Give the suggestion windows service is best or any other alternative is best ??
 

Thanks & regards,
Anilkumar
Posted 20-Aug-12 2:30am
Comments
Mehdi Gholam at 20-Aug-12 7:31am
   
Your question makes no sense.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

If this is a pure SQL task, I'd just use a scheduled task in SQL Server. Otherwise, if you need to add logic, a service is best.
  Permalink  
Comments
ajay.anilmaddi at 20-Aug-12 7:34am
   
Its not Pure SQL Task, Windows service is best or web service is best??
Christian Graus at 20-Aug-12 7:35am
   
Do you know what a web service is ? A web service is clearly useless for this task, a windows service is what you need
ajay.anilmaddi at 20-Aug-12 7:37am
   
ThankQ !!
ajay.anilmaddi at 20-Aug-12 7:40am
   
Can you give any more info or plz send any link regarding this !!
Christian Graus at 20-Aug-12 7:43am
   
Google broken where you live ? Google 'C# windows service'
ajay.anilmaddi at 20-Aug-12 7:44am
   
Ohhhhhhhh, Thanks a lot !!!!!
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

hii,
i think windwos service is best option
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Hi,
 
One more option is to create Windows Task scheduler. you can execute your dot net executable file with time interval.
 
Window service is also another best option.
 
Thanks
-Amit Gajjar.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 4

This can easily be done by scheduling a Job in SqlServer. Refer the following link for the details on how this can be done.
 
http://msdn.microsoft.com/en-us/library/ms187910.aspx[^]
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 505
1 Maciej Los 325
2 Richard MacCutchan 265
3 Mathew Soji 220
4 BillWoodruff 210
0 OriginalGriff 8,804
1 Sergey Alexandrovich Kryukov 7,457
2 DamithSL 5,689
3 Maciej Los 5,279
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web03 | 2.8.1411028.1 | Last Updated 21 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100