Carol,
Check out these MSDN articles:
http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/ms175464.aspx
S. Davey (5/30)
MI DIT\Agency Services
7:30 A.M. - 4:00 P.M. ET
517.335.4237 (M- F CCC )
>>> "Carol Green "
<mssqldba-ezmlmshield-x69356135.[Email address protected] 05/30/07
5:55 AM >>>
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.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page