I hope somebody is here on Saturday
alter TRIGGER [insert_into_export_table_colour] ON dbo.colour
set rowcount 1
select colour_code,colour_name from inserted
insert loomdata.looms_monitor_data.dbo.colour(colour_code,colour_name) --problem line
select colour_code,colour_name from inserted --problem line
set rowcount 0
<< Cannot start more transactions on this screen. Unable to start a nested
transaction for .... A nested transaction was required because xact_abort is set off>>
Here loomdata is a linked server created in the current group of sql server.
The database loom_monitor_data actually resides in another group of sql server.
I have tested running directly in query analyzer in current group
select 'tt','test' from inserted
It is inserting record in loomdata.loom_monitor_data