Ahhhh perhaps this is my fault for not explaining fully

I fully understand it doesnt fire of the cascade fucntion when set to nocheck even if the FK property still...

ok ran

SP_MSFOREACHTABLE "ALTER TABLE ? NOCHECK CONSTRAINT ALL"

go

SP_MSFOREACHTABLE "ALTER...

and when you turn the relationship in question back on the cascade delete should come back on with it ?

or am I losing the plot 🙂

simon

I wish I could but the powers...

turn it off for speed of bulk data inserts (test data)

yes but which events do we trace ?! I want to trace when it is turned off etc by whatever...

well at least if use your first example with a cursor I can step through every FK in the database.. is there a flag in a system table that will...

Steve Jones - Editor (1/21/2008)

---

I'm not 100% sure, but it's possible that you can't open two cursors on a table variable.There might be some scope issue here.

Any reason not to...

thanks but I need to be able to do this dynamically and in code (if possible)

thanks then

~si

even better and easier !

thanks si

thank you 🙂

in the end I used

update table

set number = replace (number,substring(number,1,4),6666)

seemed to work ok

kind regards

si

thank you one and all

I shall have a play

one final question ,w aht would be the preferred approach, a database table idea as I set out to do when...

I try

Select TOP 5000 distinct A.First_Name, B.Last_Name

From firstandlast A CROSS JOIN firstandlast B

ORDER BY NEWID()

and

Server: Msg 156, Level 15, State 1, Line 1

Incorrect...

One of those Eureka moments where having revisited the question and re-read your reply it makes perfect sense !

thank you !

kind regards

~si

Hi , now that I shall have to check

 

thanks for the advice

 

si

win 2003

SQL 2005 Enterprise, existing instances both at sp2

cheers 🙂

~si