Delete

Hello,
I want to delete a record from one of my tables. When i delete it, it is
deleted, but when i close and open it, it's still there. why? It just happen
s
to this table. The other tables are ok.
Thanks in advanceUnbelievable, is there a trigger on the table which cancels the
transaction ?
-Jens Suessmeyer.|||Silly question ... but are you in fact deleting it and are you getting a
confirmation that the rows are actually being deleted (i.e. 5 rows affected
etc.,)?
Is there a proper key on the table? For example, you can't delete rows from
a table using SQL enterprise administrator where there are more then one
idential rows (you will get an error - "Too many rows affected", and
ultimately the rows won't delete).
This is weird ...
"Mathew" <Mathew@.discussions.microsoft.com> wrote in message
news:358BC054-33A3-4DD0-80F7-8D5403211CC4@.microsoft.com...
> Hello,
> I want to delete a record from one of my tables. When i delete it, it is
> deleted, but when i close and open it, it's still there. why? It just
> happens
> to this table. The other tables are ok.
> Thanks in advance|||You most likely have Implicit transactions turned on. This means each time
you issue the Delete it gets wrapped in a transaction. But it is up to you
to issue the commit. If you don't when you close the connection it will get
rolled back and still be there. There is nothing weird about that.
Andrew J. Kelly SQL MVP
"Mathew" <Mathew@.discussions.microsoft.com> wrote in message
news:358BC054-33A3-4DD0-80F7-8D5403211CC4@.microsoft.com...
> Hello,
> I want to delete a record from one of my tables. When i delete it, it is
> deleted, but when i close and open it, it's still there. why? It just
> happens
> to this table. The other tables are ok.
> Thanks in advance