how to automatically update table in sqlserver 2005

I have one table in sql server 2005.it is updating from different table .I want to do these updates automatically everyday.
peterstiAsked:
Who is Participating?
 
Alpesh PatelAssistant ConsultantCommented:
Create trigger on tables from where you are updating thjs table.

Or create SSIS package to get update from all tables.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
what is the question, actually?
how to formulate the UPDATE/INSERT/DELETEs needed, or how to run the code "every day"?
if it's the second part, you "just" schedule the SQL, with either the sql agent, or, if that is not available, you run the sql using sqlcmd command line tool from within the windows scheduled task
0
 
peterstiAuthor Commented:
good
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.