Daniel,

Merge replication is designed to do most of what you need but from application stand point you just have to be carefull to perform primary key partitioning if at all...

BEGIN TRANSACTION

Delete from Table#1 Where lastName='Adams'

if @@error <> 0  goto QuitwithRollBack

Delete From Table#2 Where  lastName='Adams'

If @@error <> 0 goto QuitwithRollBack

COMMIT TRANSACTION

RETURN (0)

QuitWithRollBack:

If @@TRancount > 0  ROLLBACK TRANSACTION

RETURN (1)

Although I agree 100% to the article I have to face reality

I come from an egineering background an I firmly believe that there is...

The overhead Remi is talking about is:

For each insert in Customer, Orders and Order Detail The index in the view has to be refreshed! therefore it may speed up the reading...

Why are you using dynamic SQL?

what is the problem with this:

exec master.dbo.xp_smtp_sendmail @FROM= ?, @From_Name= ? , @TO= ?, @server= ?, @Message= ?, @Subject= ?

just make sure you map all...

you can also script

sp_changeobjectowner

'objectname', 'dbo'

OR

if you are willing to give the developers that kind of control use

sp_addalias @loginame =  'developerLogin',  @name_in_db =  'dbo'

after that, all objects will...

Does this helps:

http://www.mvps.org/access/forms/frm0005.htm

http://www.mvps.org/access/bugs/bugs0012.htm

you don't need "distinct"

SELECT

 [Unique ID],

    SUM([Line Amount])

FROM

    <tablename>

GROUP BY

    [Unique ID]

Have you tried MAXDOP =1 ?

Yep

You are right but that is what the poster said

... TableA A LEFT JOIN TableB B on A.FIELD1  =  B.FIELD1

Anthony,

I think this is just an approach problem. If you need to populate those fileds once it does not really matter is it takes a little longer. My advice though...

If the query can be performed repeatedly and different parameter values then without doubts,  go for the stored procedure! 

hth

What application programming language are you using?

- That platform will give you the answer you need!

Just out of curiosity, Does that target  table has a delete trigger ?

I am pretty sure you have to drop the foreign Key first!

Then do the alter

and later recreate the Foreign Key.