Transactions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I've read the descriptions of the types of transactions but for some reason
I am still confused... what locking mode do you use if you want dirty data
to be able to be read while a transaction is in place?

I want to be able to fill a table in a transaction but allow others to view
it as its filled into the SQL Server but if an error occurs during the
fill to roll it back...

Thanks!


.

Relevant Pages

  • Re: Tracing IPs
    ... then you're talking about how easy is it to spoof an originating IP ... That narrows the request reason down a bit. ... transaction, specifically its HELO or EHLO transaction, to be absolutely any ... way is for a spammer or virus to "bounce" a message as undeliverable to some ...
    (microsoft.public.security.virus)
  • Re: Hot Backup - D3/Linux
    ... hot-backup found any reason to use transaction-logger in conjunction ... Hot backup takes the transaction log from the master machine and distributes it to the slave machine, ...
    (comp.databases.pick)
  • Re: Oyster PAYG on rail to the edge of zone
    ... Is there a technical reason why it's hard to make ticket machines or ticket office equipment capable of activating auto top-up? ... then i can't think of a good reason. ... The fundamental reason is that the card processors insist that the inital setup transaction is processed in the same way as the ongoing transactions, and it isn't practical to carry out this type of transaction at a ticket office. ...
    (uk.transport.london)
  • capturing and returning system errors to client application
    ... I am trying to catch an SqlException in an asp.net 3.5 client. ... A stored proc to insert a headline called Headlines_Insert. ... commit transaction ... 'This is being ignored like there is no exceptions for some reason. ...
    (microsoft.public.sqlserver.programming)
  • Re: Problem saving records from code
    ... so you are using the Click event of the command button. ... unless there is some reason why you cannot move ... > transaction record I just created. ... >>> that form to open the frmIncidents that captures incident for current ...
    (microsoft.public.access.formscoding)