Hello all,

Had a bit of a weird one earlier - I was trying to create a foreign key
but both Management Console and Enterprise Manager just hung. Same thing
when using both code (ALTER TABLE MyTable ADD FOREIGN KEY (MyID)
REFERENCES AnotherTable(ID)) and using GUI

:(

Checked for blocks using sp_who2 - nothing.

I did notice that there were a lot of foreign keys referencing the same
column that I wanted to reference (about 26. After I deleted some of
these (there were a few that referenced obsolete tables), I was able to
run the code and create the foreign key constraint.

Is there a limit to the number of foreign key constraints on a column
and am I going to run into a problem if I need to create more???

(SQL Server 2000 SP4 (build 2039))

Carol.




This email and any files transmitted within it are private and confidential.
If you are not the intended recipient, this email and any attachments within it have been transmitted to you in error.
You are prohibited from using, copying, distributing or otherwise using the information contained within this email.
Nothing in this email message amounts to a contractual or legal commitment on the part of Optilan unless confirmed by a communication signed on behalf of the company.
Any email cannot be guaranteed to be secure, error free or free from viruses. Although every possible care is taken by Optilan, Optilan does not accept any liability whatsoever for any loss or damage which may be caused as a result of the transmission of this message by email.


MS Sql Server LazyDBA home page