Re: TRANSACTION QUESTION

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 11/16/04 

Date: Tue, 16 Nov 2004 17:44:52 -0500

Not with SQL2000. SQL2005 will provide a way. If you are talking about in
a trigger you always have the deleted virtual table. 

-- 
Andrew J. Kelly  SQL MVP
"PATI" <PATI@discussions.microsoft.com> wrote in message 
news:6B476DE1-31F3-45F8-8882-4DA9888057FB@microsoft.com...
>I have an application which connects to the database through ODBC.
>
> Is there a way I can read OLD value of transactions that has not been
> commited?
> (Just like ORACLE does).
>
>

Relevant Pages

  • Re: lastmodified
    ... Andrew J. Kelly SQL MVP ... >> UPDATE YourTable SET = GETDATE ... >> Andrew J. Kelly SQL MVP ... >>> Can someone provide me a simple trigger where it updates a lastmodified ...
    (microsoft.public.sqlserver.security)
  • Re: which statement fire the trigger ?
    ... What I meant was you can see the events leading up to the trigger and then ... the trigger execution so you should be able to deduce what caused it. ... Andrew J. Kelly SQL MVP ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Triggers and Data Driven Query
    ... I figured it was some kind of audit trail but I couldn't determine how this: ... You state you can see the trigger firing but you still don't say ... Andrew J. Kelly SQL MVP "David Fuller" wrote in message ...
    (microsoft.public.sqlserver.dts)
  • Re: Newbie Question - Creating Triggers within Stored Procedures
    ... Aaahhhh...thank you, Andrew. ... > You can't have a GO in the stored procedure code. ... > pieces (table creation and trigger etc) in Dynamic sql though. ... > Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.programming)
  • Negative results
    ... Andrew J. Kelly wrote: ... Sorry thanks for pointing that out Kevin. ... Andrew J. Kelly SQL MVP ... Your best option to begin with is to look at the virtual file stats to seehow ...
    (microsoft.public.sqlserver.server)