Refresh the table every night

Question

0.00/5 (No votes)

See more:

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 1:30am

ajay.anilmaddi

Add a Solution

Comments

Mehdi Gholam 20-Aug-12 7:31am

Your question makes no sense.

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Christian Graus · Answer 1 · 2012-08-20T01:31:00

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.

Posted 20-Aug-12 1:31am

Christian Graus

Comments

ajay.anilmaddi 20-Aug-12 7:34am

Its not Pure SQL Task, Windows service is best or web service is best??

Christian Graus 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 20-Aug-12 7:37am

ThankQ !!

ajay.anilmaddi 20-Aug-12 7:40am

Can you give any more info or plz send any link regarding this !!

Christian Graus 20-Aug-12 7:43am

Google broken where you live ? Google 'C# windows service'

ajay.anilmaddi 20-Aug-12 7:44am

Ohhhhhhhh, Thanks a lot !!!!!

Ganesh Nikam · Answer 2 · 2012-08-20T02:16:00

Solution 2

hii,
i think windwos service is best option

Posted 20-Aug-12 2:16am

Ganesh Nikam

**AmitGajjar** · Answer 3 · 2012-08-20T19:32:00

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.

Posted 20-Aug-12 19:32pm

AmitGajjar

Rahul Rajat Singh · Answer 4 · 2012-08-20T19:36:00

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[^]

Posted 20-Aug-12 19:36pm

Rahul Rajat Singh