Post reply

How to fire trigger each day automaticaly my table

  • July 22, 2009 at 1:11 am

    #95831

    Hi all,

    i am using sql server 2005

    how to write trigger for......................

    How to fire trigger each day automaticaly my table(select the data today adte to above records)

  • July 22, 2009 at 1:16 am

    #1028109

    Please don't start multiple threads for the same problem.

    Asked and answered: http://www.sqlservercentral.com/Forums/Topic757156-145-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 22, 2009 at 1:17 am

    #1028110

    polo.csit (7/22/2009)

    Hi all,

    i am using sql server 2005

    how to write trigger for......................

    How to fire trigger each day automaticaly my table(select the data today adte to above records)

    Triggers will fire for every insert,update and delete commands issued on the table. On a OLTP it will cause a performance degrade. If your requirement is only selecting the data that is inserted or modified today consider scheduling a job for that instead of a trigger. Can you exactly tell what is your requirement.

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • July 22, 2009 at 3:09 am

    #1028157

    Is that possible to put this in a job and schedule it run on daily basis.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply