sql-server / rollback

[Achim Künstler]

hi,

does anybody know something about sql-server and rollback ?
my problem: I added some data to a database but the writing process
was aborted, now I'm not sure if the the data are in the database or
not ?
Does the sql-server support the feature rollback automaticatly ?

thx. for your help and sorry for my bad written english ;-)

Achim

[Greg D. Moore \(Strider\)]

Re: sql-server / rollback


"Achim Künstler" <atschim@gmx.de > wrote in message
news:e9f798d4.0 309120604.d9c89 e9@posting.goog le.com...[color=blue]
> hi,
>
> does anybody know something about sql-server and rollback ?
> my problem: I added some data to a database but the writing process
> was aborted, now I'm not sure if the the data are in the database or
> not ?
> Does the sql-server support the feature rollback automaticatly ?[/color]

Yes, rollbacks are automatic.

MS SQL Server is fully ACID compliant.

[color=blue]
>
> thx. for your help and sorry for my bad written english ;-)
>
> Achim[/color]

[Joseph Weinstein]

Re: sql-server / rollback



"Greg D. Moore (Strider)" wrote:
[color=blue]
> "Achim Künstler" <atschim@gmx.de > wrote in message
> news:e9f798d4.0 309120604.d9c89 e9@posting.goog le.com...[color=green]
> > hi,
> >
> > does anybody know something about sql-server and rollback ?
> > my problem: I added some data to a database but the writing process
> > was aborted, now I'm not sure if the the data are in the database or
> > not ?
> > Does the sql-server support the feature rollback automaticatly ?[/color]
>
> Yes, rollbacks are automatic.
>
> MS SQL Server is fully ACID compliant.[/color]

Hi. To be clear though, if you didn't start your writing process by starting a traansaction,
then if your inserts were via a series of insert statements, then each insert was it's own
transaction, and every insert statement that got to the DBMS most likely got executed.
Joe
[color=blue]
>
>[color=green]
> >
> > thx. for your help and sorry for my bad written english ;-)
> >
> > Achim[/color][/color]