Good question, but there's an error in the explanation of the answer. At the end, it should say "with a maximum for TheValue of less than 3", not "less than...

Oleg,

Interesting...

What I am getting when I run your example of handling a text data type is:

insert into dbo.test ([col1], [col2]) values (0x00000001, 0x73616d706c6520312c73616d706c652031);

insert into dbo.test ([col1], [col2]) values (0x00000002, 0x73616d706c6520322c73616d706c652032);

When...

Very good article. This technique could be very useful to me right now.

I tried it on a relatively small, simple table and it worked fine. However, on a larger table...

Very good article. This technique could be very useful to me right now.

I tried it on a relatively small, simple table and it worked fine. However, on a larger table...

OMG. That was terrible!

For the delete constraint try:

select constraint_name, delete_rule

from information_schema.referential_constraints

where constraint_name = [the foreign key name]

Also, if you have Red Gate software, it will compare two databases and create scripts to synchronise one to the other, taking referential integrity into account. But this is 'by...