I've always found this site useful as it tell you what you need to bring a release up to a certain build

http://www.aspfaq.com/show.asp?id=2160

the solution i used was to:

1. identify all the records i needed to change and compute a span value of the history records missing

2. cylce through these using a cursor...

Apologies and I've deleted the original reply

I'm in the UK so the reply was made this morning.

It is a big system, poorly designed...

I think this may do it ...

EXEC sp_MSforeachtable @command1= 'alter table ? nocheck constraint all'

and to get them back

EXEC sp_MSforeachtable @command1= 'alter table ? check constraint all'

of course this would...

try this

select replace('tester''s', '''','''''')

>tester''s

>(1 row(s) affected)

you need to double (escape) the single quotes so SQL Server can parse them

yeah kind of

each account has a number of history records and so i need to 'back fill' the missing history records for each account.

i've rewritten the query to returna table...

I haven't tried your code yet.

What I need to do is iterate over possible millions of records that have associated history records that have a sequence 1.. n

I need to...

this was only a test harness of kinds so i could be sure that i was generating the right sequences for the inserts with each insert having and incrementing value.

i think you were right - i didn't really explain myself at all

I was kind of typing what I was thinking ...

The reason I was using a function was I have to write a routine that will iterate over a table and...

My XBox arrived this morning.

Once again, thank you very much and keep up the good work

Many thanks

Steve

Many thanks to all.

I'll give your suggestions a go.

this is turning into a real enigma ...

i wrote a set of queries to remove the paralellism and cut the execution time to 16 mins (from 20+ hours with some...

The article did apply to use - yes we are on the latest service pack - yes we had parallellism turned on and yes we tried turning it off. nothing...

I always replace them with double single quotes going into the db - the place I used to work at had a function that pre-processed the text going into the...