Re: Problem with execution
From: Johny (goky2002_at_beograd.com)
Date: 10/25/04
- Next message: mitra: "Re: How to drop only one of the Constraints"
- Previous message: Noor: "Re: Handling duplicates in linked server and dealing with raised error"
- In reply to: John Bell: "Re: Problem with execution"
- Next in thread: John Bell: "Re: Problem with execution"
- Reply: John Bell: "Re: Problem with execution"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 25 Oct 2004 17:44:52 +0200
It's just hangs. I saw that when I traced what is happening and that
confusing me.
I can execute it from from Query Analyzer without any problems. It's not
problem with delete. Somehow it seems that problems is with multiple
execute.
"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:OeZT1oouEHA.1296@TK2MSFTNGP10.phx.gbl...
> Hi
>
> You don't say if it just hangs (in which case you are probably blocked) or
> if you get an error message. You may want to use TRUNCATE instead of
delete
> if you wish to delete everything from the table.
> It may also be an idea to put this in a transaction and add error handling
> (see @@ERROR in Books online).
>
> John
- Next message: mitra: "Re: How to drop only one of the Constraints"
- Previous message: Noor: "Re: Handling duplicates in linked server and dealing with raised error"
- In reply to: John Bell: "Re: Problem with execution"
- Next in thread: John Bell: "Re: Problem with execution"
- Reply: John Bell: "Re: Problem with execution"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
