I have a table that has triggers on insert update and delete. The triggers perform modifications on another table on a remote databased(linked server).
All triggers make a join between the tables inserted, deleted and the remote table.
When running a profile on the remote database it seems that the following query is done on the remote table by the triggers.

"Select * from Database.dbo.Table"

The triggers are the only entities accessing the remote table from the original server so the query must come from them. My only conclusion is that MSSQL server is doing this query for some kind of "optimization".

Has anyone seen this before?
How can I work arond this? The remote table is BIG and this query happening every few seconds in a problem for me.

Thanks

Robert