Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-09 : 12:38:32
|
| writes "HelloI would like to do databse Updations(Through Stored Procedures) Everyday with out triggering any Event. Any Body can help me Pleeeese....Thanks!" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-09 : 13:26:35
|
| I'm not sure what you mean by "not triggering any event". If you mean that you want these UPDATEs to occur without user intervention, then you can create a SQL job, and then schedule the job to run at any interval or frequency you wish. Books Online has details on how to do this, look up "sp_add_job", "sp_add_job_schedule", "sp_add_job_step", and "jobs". |
 |
|
|
|
|
|
Triggerrs in Sql Server