Professional Web Applications Themes

Clear a log data table - Microsoft SQL / MS SQL Server

I need to clear a log data table. Problem is when to clear. If I insert a trigger operation in the user's table, it mean that every user login trigger fires and start delete operation, but in this way too much delete will be executed (and I think that it's not a right thing). When will y insert those kind of operation? -- Sincerely Andrea Moro...

Sponsored Links
  1. #1

    Default Clear a log data table

    I need to clear a log data table. Problem is when to clear.
    If I insert a trigger operation in the user's table, it mean that
    every user login trigger fires and start delete operation,
    but in this way too much delete will be executed (and I think that
    it's not a right thing).

    When will y insert those kind of operation?

    --
    Sincerely
    Andrea Moro


    Sponsored Links
    Andrea Guest

  2. #2

    Default Re: Clear a log data table

    It's built into sql server. Actually it's a separate service but comes
    packaged with Sql Server and is called the SQL Agent. This allows you to
    schedule virtually any kind of task you wish. See SQL Agent or Scheduled
    Jobs in BooksOnLine for more info.

    --

    Andrew J. Kelly
    SQL Server MVP


    "Andrea Moro" <it> wrote in message
    news:eXN$phx.gbl... 


    Andrew Guest

  3. #3

    Default Re: Clear a log data table

    Thanks. And - I didn't see anything yer - but it's available
    on MSDE and is programmable througt a SP, for example
    to modify behaviour?

    --
    Sincerely
    Andrea Moro


    Andrea Guest

  4. #4

    Default Re: Clear a log data table

    If you are using MSDE, then you have to program everything through
    Transact-SQL and system stored procedures. The job is created with
    sp_add_job, sp_add_jobstep, sp_add_jobscedule. You will need to use OSQL.exe
    or some other method of ending commands to the server.

    Spend some time in BOL for details.

    If you have the full version of SQL Server, there is a job wizard available
    in the Enterprise Mananger.

    Bob Castleman
    SuccessWare Software

    "Andrea Moro" <it> wrote in message
    news:phx.gbl... 


    Bob Guest

  5. #5

    Default Re: Clear a log data table

    Bob ... you gaved me a nice reply. I want to do all throught
    sp also in Full SQL Version

    --
    Sincerely
    Andrea Moro



    Andrea Guest

Similar Threads

  1. Replies: 0
    Last Post: June 1st, 03:15 AM
  2. How to clear a data grid?
    By Kwooda in forum Macromedia Flex General Discussion
    Replies: 8
    Last Post: May 25th, 10:18 AM
  3. Replies: 4
    Last Post: October 27th, 03:01 PM
  4. Trouble copying data from old table to new table
    By RelentlessMike in forum Coldfusion Database Access
    Replies: 3
    Last Post: May 19th, 05:01 PM
  5. Replies: 1
    Last Post: July 9th, 03:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139