Re: Trigger Question
From: vul (aaa_at_optonline.net)
Date: 12/03/04
- Next message: ChrisR: "deadlock question"
- Previous message: Patrick: "Update text filed from QA"
- In reply to: Rajesh Peddireddy: "Trigger Question"
- Next in thread: Louis Davidson: "Re: Trigger Question"
- Reply: Louis Davidson: "Re: Trigger Question"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 3 Dec 2004 13:22:46 -0500
Thank you.
Everything looks correct for me. But trigger doesn't work as I expected.
Al
"Rajesh Peddireddy" <anonymous@discussions.microsoft.com> wrote in message
news:052201c4d958$fe439d50$a501280a@phx.gbl...
> Hey
>
> Just check the login name and owner of the object related
> stuff..
>
> Its just an idea ..
>
> Thanks
> Rajesh Peddireddy
>
>
>
> >-----Original Message-----
> >I have a trigger:
> >
> >CREATE TRIGGER Ordr_Delete ON [dbo].[Ordr]
> >FOR DELETE
> >AS
> >DECLARE @OrderID int
> >SELECT @OrderID=OrderID FROM deleted
> >DELETE FROM OrderDetail WHERE OrderDetail.OrderID=@OrderID
> >
> >If I delete a record from table Ordr directly in EM or
> run delete statement
> >from VB6 application then all records from OrderDetail
> table are deleted
> >with no problem too. So everything is as I expected.
> >If I run delete statement from Query Analyzer then the
> record from Ordr
> >table is deleted, but records in OrderDetail table remain
> untouched.
> >Why?
> >Thank you
> >Al
> >
> >
> >.
> >
- Next message: ChrisR: "deadlock question"
- Previous message: Patrick: "Update text filed from QA"
- In reply to: Rajesh Peddireddy: "Trigger Question"
- Next in thread: Louis Davidson: "Re: Trigger Question"
- Reply: Louis Davidson: "Re: Trigger Question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
