never heard of the term "broken tables"....could you be more specific?

are you getting an error, or some unexpected results? Can you explain it better or in a different way?

it would...

i'm not sure what you want for the actual rule...you say both insert and update, and i don't know if you are talking about multiple rows or editing a single...

this is usually done at the presentation layer, not at the database level.

this kind of logic is hard to do...what is meant by 3rd time? ever? or 3 times in...

thanks for the better look at the schema; all follow up after testing.

you might be confused as to how the Identity() property on a column works, and also what is...

i think it was a script i wrote and contributed:

Default Trace Load of All 5 Files

something i put together because i got annoyed to have to find the...

psuedocode sucks....i know...

what are the REAL table names and theuir primary key columns....they aren't really named Table1 are they?

can you post the CREATE TABLE for your 4 tables?

sorry...

my point is we need to fix the job, not continue to work around a time constriant and try to stop/disable/continue.

lots of issues can be killing your job:

out of...

it's always the little things that cost the largest amounts of time; I've gotten zapped like that when i was playing in case sensitive databases.

an extra pair of eyes helps...

i always move the data in FK Hierarchy order; it makes sense when you look at it today, and 6 months from now when you add other tables.

stored procedure is...

you'll need to paste the trigger in question, so we can see what the issue is.

it's not obvious, but the table definition says 'eeo'_Classification, but the insert is 'ee0'_Classification

so the chars look the same, but the "O" is not the same character "0" in...

if you can provide the actual CREATE TABLE statements, and a few rows of sample data, we could really help a lot better.

off hand, i think you'll update table2 before...

psuedo code wastes your time and mine...give us the specifics so we can help with specific answers.

1. Import the table [message]from server a to server b

--are you doing this to...

you can do it by comparing the COLUMNS_UPDATED function to see if specific columns have changed, and only let the trigger run if that is true; it uses a bitmask...

one of Florian's many points is this:

SQL server does not natively have a rollback after x seconds functionality. because a database needs to preserve ATOM-ocity, it's an all-or-nothing scenario,...