June 25, 2003 at 11:08 am
Can you post the T-SQL code behind the tables and specifically the foreign key constraints?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
June 25, 2003 at 12:21 pm
I'm getting this error.
'Site_Visitor' table saved successfully
'Site_Visitor_List_Topics' table
- Unable to create relationship 'FK_Site_Visitor_List_Topics_Site_Visitor'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Site_Visitor_List_Topics_Site_Visitor'. The conflict occurred in database 'hudsonorg', table 'Site_Visitor', column 'site_visitor_id'.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply