Professional Web Applications Themes

Inserting Data Outside A Transaction - Microsoft SQL / MS SQL Server

I have a set of queries all within a single transaction. I would like to insert logging information into another table. However, I would like this to be done outside the transaction, as I don't want it to be rolled back if there is an error. Is there a query hint / option that I can use to tell SQL to do a query outside the transaction? I am not SA so I don't have the ability to use command shell / or start SQL jobs. Any help would be appreciated....

  1. #1

    Default Inserting Data Outside A Transaction

    I have a set of queries all within a single transaction. I would like
    to insert logging information into another table. However, I would
    like this to be done outside the transaction, as I don't want it to be
    rolled back if there is an error.

    Is there a query hint / option that I can use to tell SQL to do a
    query outside the transaction?

    I am not SA so I don't have the ability to use command shell / or
    start SQL jobs.

    Any help would be appreciated.
    Cocoa Monkey Guest

  2. #2

    Default Re: Inserting Data Outside A Transaction

    If you transaction is started inside of a stored procedure, then all you
    need to do is write the audit insert outside the transaction block. If the
    transaction is started by an application, you can just log the information
    from the application code again.
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    [url]http://www32.brinkster.com/srisamp[/url]

    "Cocoa Monkey" <mhoyleiisltd.com> wrote in message
    news:5e198a3e.0307030355.294e6b8dposting.google.c om...
    > I have a set of queries all within a single transaction. I would like
    > to insert logging information into another table. However, I would
    > like this to be done outside the transaction, as I don't want it to be
    > rolled back if there is an error.
    >
    > Is there a query hint / option that I can use to tell SQL to do a
    > query outside the transaction?
    >
    > I am not SA so I don't have the ability to use command shell / or
    > start SQL jobs.
    >
    > Any help would be appreciated.

    SriSamp Guest

Similar Threads

  1. Inserting data to SQL
    By toby007 in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: April 18th, 03:38 AM
  2. Replies: 2
    Last Post: March 8th, 11:57 AM
  3. Inserting Data
    By robert_raw webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 1
    Last Post: July 16th, 03:01 PM
  4. Replies: 1
    Last Post: July 10th, 08:29 PM
  5. inserting data...
    By Geoff Berrow in forum PHP Development
    Replies: 1
    Last Post: June 27th, 02:31 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