Thanx for the performance pointer frank. But can you explain to me why your version is faster than the one I posted?

Update YourTable set f1 = 'UserInput' ... where PkCol1 = ? and PkCol2 = ? and PkCol3 = ? and PkCol4 = ?

The only thing I can think of for...

Please don't use cursors when you can use a set based solution. This will run so much faster on the production system :

Update P set P.cStock = P.CStock -...

From somewhere on this site (don't have the URL to give credit)

CREATE FUNCTION [dbo].[getMthEndDate] (@date datetime)

RETURNS DATETIME

AS

BEGIN

RETURN dateadd(month,1+datediff(month,0,@date),0) - 1

END

you must specify the precision :

declare @var decimal (7,4)

The only backup I found was well over 20 months old and I already used it to recover as much data as possible

I had considered trying their software but

1...

He doesn't want to disable them he wants to remove the on delete cascade option and there's no option but to redo the constraints.

this is a good start :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=144674

this script (last post of the thread) will allow you to generate all the create DDL. You can inspire yourself from...

You'll have to drop all foreign keys and recreate them. I have no ready made script for that. But maybe someone here has one.

Looks to me like you have the situation under controle... Just make sure you have a full backup of the database before reloading the table... in case another bug screws...

Ok, the only other thing I can think of is trying to drop the table and recreate it (almost like EM does when you save the changes made to a...

I've already experienced something like this. What "made it work" was that I restarted EM and the offending objects were gone. For some reason the refresh methods didn't...

That works great if you have no gaps or if you want even or odd pks.. but if you really want row #1,#3,#5, or #2,#4,#6... try this :

CREATE TABLE...

This will do the trick for the business rule described. As long as it doesn't conflit with any other rule then you'll be fine.

Well I'm restoring my own mess here... I'm the only one involved in IT so I do pretty much everything except advanced networking.

So I got no time left for...