<div>
Hi,<br />
Your problem is when you issue your delete SQL Server checks for constraint violations before it executes the trigger. &nbsp;So your trigger never even gets fired. &nbsp;This is a common problem. &nbsp;You have 2 options for enforcing pk-fk relationships:<br />
1. &nbsp;triggers or<br />
2. &nbsp;pk-fk constraints<br />
<br />
You can't do both. &nbsp;If you want to enforce referential integrity using triggers then you cannot define primary key and foreign key constraints on the columns.<br />
<br />
hth,<br />
andrew
</div>


Hi,
Your problem is when you issue your delete SQL Server checks for constraint violations before it executes the trigger.  So your trigger never even gets fired.  This is a common problem.  You have 2 options for enforcing pk-fk relationships:
1.  triggers or
2.  pk-fk constraints

You can't do both.  If you want to enforce referential integrity using triggers then you cannot define primary key and foreign key constraints on the columns.

hth,
andrew

<div>
But..., if i have foreing keys how can i remove it from SQL Enterprise Manager easily, i could not find a option for this...
</div>


But..., if i have foreing keys how can i remove it from SQL Enterprise Manager easily, i could not find a option for this...

<div>
I have no diagrams built but works with the command. Thanks
</div>


I have no diagrams built but works with the command. Thanks

<div>
<div class="content wysiwyg-content">
I want modify relation between tables, in the next way: i just wanna delete this relation. Why that: when i delete a record, i launch a trigger that updates all tables where this record is envolved, but i get the next message:<br />
<br />
DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_ResMetod_Pet'. The conflict occurred in database 'AbxData', table 'ResMetod', column 'Pet'.<br />
<br />
Hope somebody can help me.<br />
thanks<br />

</div>
</div>


I want modify relation between tables, in the next way: i just wanna delete this relation. Why that: when i delete a record, i launch a trigger that updates all tables where this record is envolved, but i get the next message:

DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_ResMetod_Pet'. The conflict occurred in database 'AbxData', table 'ResMetod', column 'Pet'.

Hope somebody can help me.
thanks


MODIFY CONSTRAINTS

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.