Just make sure that the date is kept is numerical order in the db, and that you send the parameters in numerical order. Unless the order is relevant to...

Sorry for the delay :

DECLARE @demo table (RowID int not null identity (1,1) primary key clustered, name varchar(10) not null)

Insert into @demo (Name)

Select 'cats'

UNION ALL

Select 'dogs'

UNION ALL

Select 'birds'

UNION ALL

Select...

There's still the question of why you think you need dynamic sql here...

I just tried to create it and it popped the errors. You can do that in enterprise manager or in query analyser. Also you need to finish the...

I'm not sure this is what you need but let's see :

CREATE PROCEDURE dbo.test (@ID int,@1 smallint,@2 smallint,@3 smallint,@4 smallint,@5 smallint, @MystNumber int, @Match bit output, @Mystery bit output)...

Sorry... no clue how to solve that problem. Can you give an exemple of the code that makes it fail?

Open query analaser, connect to server, expand the db in the objects browswer, expand the sps, right click, debug. then you'll have to input the parameters of the proc,...

That's just part of her disguise.

Just go to the linked server and do the insert from there... It's gonna be faster that way... and won't take a loop.

Time for some more constructive comments... Can you clean up the data before it's too late?

Is tempdb full?

Are the db files set to a fixed size?

Yup .

And I just thaught of a few more :

How many relations do you have on that tables?

Do you have insert triggers?

Do...

I'm gonna go on a limb here and assume that there's more to the script. Can we know why you think you need dynamic sql here?

Cause if that's all...

You can either use a stored proc to do the delete from the main form (and manually delete from all 4 tables). Or you can use on delete cascade...

No offense but inserting only 35k records shouldn't take long. How large is the table?

How many indexes are there on the table?

What's the Primary/key, clustered index?

How long does it...