Re: impossible to delete rows
From: Uri Dimant (urid_at_iscar.co.il)
Date: 06/10/04
- Next message: Bob Barrows [MVP]: "Re: How to read an SQL Server into a ASP page and then change, add, delete and write it back to SQL Server"
- Previous message: Jeff Cochran: "Re: How to read an SQL Server into a ASP page and then change, add, delete and write it back to SQL Server"
- In reply to: HPA: "impossible to delete rows"
- Next in thread: HPA: "Re: impossible to delete rows"
- Reply: HPA: "Re: impossible to delete rows"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 10 Jun 2004 15:03:20 +0200
HPA
Have you ran SQL Server Profiler to caputre what is going on durung
delition.?
"HPA" <henri-pierre.auclair@tele2.fr> wrote in message
news:%MXxc.51083$zm5.26156@nntpserver.swip.net...
> Hi all,
> I try to delete about 4000 rows in a table which contains 150000.
> This table is referenced with DRI in several other tables (inheritance or
> foreign key).
> The firts instructions of the stored procedure delete the rows in the
> associated tables, and the last one is as simple as :
> delete myTable
> where myColumn = myValue,
> (there is an index on myColumn).
> The associated rows are deleted, but the last instruction does not
execute,
> although I get no error message (SQL Server uses 99% of the CPU, nothing
> happens...)
> I'm the only user of this database, so I don't understand what can lock
the
> rows.
> Thanks for your help !
>
> config : SQL Server 2k SP3 - Win2k pro SP4
>
>
>
- Next message: Bob Barrows [MVP]: "Re: How to read an SQL Server into a ASP page and then change, add, delete and write it back to SQL Server"
- Previous message: Jeff Cochran: "Re: How to read an SQL Server into a ASP page and then change, add, delete and write it back to SQL Server"
- In reply to: HPA: "impossible to delete rows"
- Next in thread: HPA: "Re: impossible to delete rows"
- Reply: HPA: "Re: impossible to delete rows"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
