HELP: No Cascade Delete in MSDE! (SQL Server)

I am trying to delete a record from a database using ADO.NET (with VB.NET),
but because there are relationships defined in my MSDE db it produces a
referential integrity error.

In Access it automatically cascade deletes! How can I do this with MSDE?

Martin
Sat Feb 07 08:16:00 CST 2004

This is available from SQL2000/MSDE 2.0 onwards.

"VB Programmer" <growNO-SPAM@go-intech.com> wrote in message
news:eRAjALA7DHA.1052@TK2MSFTNGP12.phx.gbl...
> I am trying to delete a record from a database using ADO.NET (with
VB.NET),
> but because there are relationships defined in my MSDE db it produces a
> referential integrity error.
>
> In Access it automatically cascade deletes! How can I do this with MSDE?
>
>

Mary
Sat Feb 07 08:48:29 CST 2004

You have to define it on your relationships, the same way you did in
Access/Jet. There's nothing automatic about it in either product. See
SQL Books Online, CREATE TABLE topic, FOREIGN KEY constraint.

-- Mary
MCW Technologies
http://www.mcwtech.com

On Thu, 5 Feb 2004 11:10:33 -0500, "VB Programmer"
<growNO-SPAM@go-intech.com> wrote:

>I am trying to delete a record from a database using ADO.NET (with VB.NET),
>but because there are relationships defined in my MSDE db it produces a
>referential integrity error.
>
>In Access it automatically cascade deletes! How can I do this with MSDE?
>

Marc
Sun Feb 08 03:44:35 CST 2004

>I am trying to delete a record from a database using ADO.NET (with VB.NET),
>but because there are relationships defined in my MSDE db it produces a
>referential integrity error.
>
>In Access it automatically cascade deletes! How can I do this with MSDE?

Which version of MSDE are you using? SQL Server 7 / MSDE 7 didn't have
the cascading delete feature yet- you'll need to use MSDE 2000 for
this.

You'll need to define your relationship between two tables to actually
be passing on deletes in a cascading delete fashion - it won't happen
automagically

Read up on the details in the SQL Server Books Online - really helpful
source of information on SQL Server stuff!

Marc

VB
Mon Feb 09 06:20:59 CST 2004

Thanks alot everyone!

"Marc Scheuner [MVP ADSI]" <m.scheuner@inova.SPAMBEGONE.ch> wrote in message
news:p51c20ljlec86m9ei3kn27psv4nthfrk6f@4ax.com...
> >I am trying to delete a record from a database using ADO.NET (with
VB.NET),
> >but because there are relationships defined in my MSDE db it produces a
> >referential integrity error.
> >
> >In Access it automatically cascade deletes! How can I do this with MSDE?
>
> Which version of MSDE are you using? SQL Server 7 / MSDE 7 didn't have
> the cascading delete feature yet- you'll need to use MSDE 2000 for
> this.
>
> You'll need to define your relationship between two tables to actually
> be passing on deletes in a cascading delete fashion - it won't happen
> automagically
>
> Read up on the details in the SQL Server Books Online - really helpful
> source of information on SQL Server stuff!
>
> Marc
>