Trigger in sql server 2005

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

hi,

I want to know whether i can write a trigger with the system time to execute a
stored procedure .
Please help me with some smaples

Regards
Nirmala devi Saravanan

Posted 3-Nov-12 19:26pm

Nirmala Devi Saravanan

Add a Solution

2 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)

Bala Selvanayagam · Answer 1 · 2012-11-04T01:43:00

Solution 2

You can use SQL Server "Schedule Jobs"

http://www.wiseowl.co.uk/blog/s231/schedule_data_import_in_sql_server_pt3.htm[^]

Basically, write your SQL statement (preferably) in a stored procedure and call it in your job scheduler.

If not clear, let me know and provide more details

Posted 4-Nov-12 1:43am

Bala Selvanayagam

Updated 4-Nov-12 1:44am

v3

Sandeep Mewara · Answer 2 · 2012-11-03T19:50:00

AFAIK, you cannot. They are part of the triggering SQL statement (only through autonomous transactions)

Refer:
http://en.wikipedia.org/wiki/Database_trigger[^]
http://msdn.microsoft.com/en-us/library/ms189799.aspx[^]

If you want something to be executed at a particular time interval, I would suggest you to use a Windows service instead. It can run at the time scheduled and insert/update data in your database.