<div>
Have you checked if there are any open transactions locking the table?<br />
<br />
dbcc opentran<br />
<br />
exec sp_who 50<br />
-- Where the id is the SPID from DBCC OPENTRAN<br />
<br />
exec sp_lock 50<br />
-- Where the id is the SPID from DBCC OPENTRAN
</div>


Have you checked if there are any open transactions locking the table?

dbcc opentran

exec sp_who 50
-- Where the id is the SPID from DBCC OPENTRAN

exec sp_lock 50
-- Where the id is the SPID from DBCC OPENTRAN

<div>
I tried the exec sp_Who and lock and nothing happening ....
</div>


I tried the exec sp_Who and lock and nothing happening ....

<div>
<div class="content wysiwyg-content">
Hi There <br />
<br />
I would like to create a Feoreign Key into a Table T1 .. the Foreign Key is a Primary Key in another Table T2 ..... <br />
<br />
Whene I did this even with the MgmtStudio or via SQL Script I noticed that it took too much time and finished always with this Msg : <br />
<br />
<br />
'T2' table saved successfully<br />
'T1' table<br />
- Unable to create relationship 'FK_tblManufacturingBP_tbl<wbr />BomType'. &nbsp;<br />
Timeout expired. &nbsp;The timeout period elapsed prior to completion of the operation or the server is not responding.<br />
Could not create constraint. See previous errors.<br />
<br />
What I find very strange is that T1 table is similar to another table called T3 and for which this FK was created correctly ..... Of Course, I changed names and so on ..... <br />
<br />
Any help with this <br />
<br />
Thanks
</div>
</div>


Hi There 

I would like to create a Feoreign Key into a Table T1 .. the Foreign Key is a Primary Key in another Table T2 ..... 

Whene I did this even with the MgmtStudio or via SQL Script I noticed that it took too much time and finished always with this Msg : 


'T2' table saved successfully
'T1' table
- Unable to create relationship 'FK_tblManufacturingBP_tblBomType'.  
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Could not create constraint. See previous errors.

What I find very strange is that T1 table is similar to another table called T3 and for which this FK was created correctly ..... Of Course, I changed names and so on ..... 

Any help with this 

Thanks

Can not add a Foreign Key in a Table for a TimeOut Msg Error

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.