Odd SQLTrigger Behavior

I have three tables I am using, aspnet_Users, Stories,
CustomizedStory.
  Stories and
CustomizedStory are related via a foreign key StoryID.
  I’ve setup the tables so that when I delete a
Story row it cascade deletes the corresponding row from CustomizedStory.
 
Each CustomizedStory row has a reference to UserID from aspnet_Users.
Since, I didn’t want to mess with the table definition by adding a cascade
delete option on aspnet_Users, I decide to use a trigger, essentially delete all customized stories and associated stories if a user is deleted:ALTER
TRIGGER [dbo].[DeleteCustomizedStories]

    ON [dbo].[aspnet_Users]

    FOR DELETE
AS

BEGIN

    DELETE FROM dbo.Story


            WHERE StoryID
=
   (SELECT StoryID FROM dbo.CustomizedStory WHERE
UserID =
 

   (SELECT UserID FROM deleted))
END

The problem I am having is that it deletes all of the
CustomizedStory rows as specified by the cascading option, but doesn’t delete
the Story rows.
  I can’t seem to understand
why this is happening, especially when
  I
explicitly told it to delete story rows.