Still have no clue of what you really need to do. What do you need to audit, how do you have to audit it?

What are you trying to do exactly??

There's still no other possible somewhat right answer... if the trigger fails, the whole transaction has to fail.

...and that's just the way it should be .

This will work... but if you ever have to do this more than once, I'd suggest writting it as an inner join.

Forgot that you'll have to change the xType to 'U' as well.

Maybe you could recreate the table under another name. Get its status there, then update directly the system tables (assuming you can't stop the server for a few sec...

select substring(ColumnName, charindex('bal', ColumnName), 11)

from orderitem

where writtendate = '01-sep-05'

Why did he make them system objects is really the first question to ask...

What is the problem with dts??

Not quite... check out the books online for the correct syntax.

You can use charindex on a column as well to fin the position of a string. Then you can use that information to manipulate the data as needed.

I'm still not over this one .

K... never had that requested to me .

I think I would do a normal lookup table and then add another table with the alternative namings of the key. Why do you need to do that?

The server will have to validate that the data modifications you do do not break the fk constraint. Won't have any effects on the select unless you add indexes.